a million dollar question.

As I posted before. The company I'm working for is planning to develop a new
system for our POS around the country. We want to find the best replication
model between SQL Servers.
The situation turns difficult for us since we won't have static IP's on each
POS but dynamically IP's assigned by Cable, DSL or any other ISP available.
So we may not be able to establish VPN's.
I know most of you may have plenty experience on this subject.
Actually we're doing this with Web Services and data encryption but we want
to take the best alternative.
With SQL Server CE this is easier because of replication through IIS. Is
there a similar way between SQL Servers so I can protect information with a
Certificate or something?
As you can see, I'm a newbie in this but I want to learn about it. If there's
a good course/seminar you can recommend me to take, I would really appreciate
it. If the best way to learn is trying and a good book (Paul recommended me
Hillary's one), I can take that too.
Thank you very much.
Omar Rojas.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200510/1
Having dynamic ip address doesn't prevent you to use VPN. You can have the
POS computer VPN to your network. If you set the VPN to register in the DNS
you can get to the POS my computer name.
Also, you could (and I don't think is a good idea) hardcode the IP Address
on the user (so each time they connect in the VPN server they get the same
address).
Jos.
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1
|||You can use web replication with SQL Server in much the same
way that you have used it with SQL CE. The differences are:
1. you must use SSL for SQL Server web replication (with
SQL CE you have the option not to)
2. the code you need to write if you are thinking of using
SQL Express as the subscribers is difficult and not well
documented. I'm referring here to implementing replication
using RMO programming. I've just been through this on a
large project and it was not fun.
Other than that, it's the same concept - an ISAPI DLL sits in
a virtual directory on IIS and brokers the replication to web-
connected subscribers.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1
|||replication over the web is relatively easy but somewhat involved.
Points to keep in mind.
1) your path to the snapshot subdirectory should be /ftp or /FTPVD/ftp,
where FTPVD is the name of your FTP Virtual Directory
2) your ftp server should be entered as a fully qualified domain name. This
is the option in the Snapshot location tab called FTP Server Name\
3) use anonymous authentication. If you are using not using anonymous
authentication make sure you created a local machine account with the same
name and this account has list and read access to the files and folders
underlying the ftp virtual directory.
4) Your subscribers need to find a path to your publisher across the
internet. You should register your publisher using its netbios name what you
see by issuing a master.dbo.xp_cmdshell 'echo %computername%. Use this name
as your Server alias when configuring the publisher name in Client Network
Utility on your Subscribers. Make sure the Server alias is the Server name
(i.e. Publisher), the ServerName is the Fully Qualified Domain Name to your
Publisher, i.e. Publisher.MSDN.Microsoft.com. Make sure you use the tcp/ip
network library.
Finally you will find it easy to use the replication activeX controls to
deploy subscribers, use PublisherAddress and DistributorAddress for the FQDN
for your Publisher/Distributor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1