Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Maria
Starting Member
12 Posts |
 Posted - 2002-01-07 : 11:43:03
|
Hi!!Hope everyone had happy holidays!I was wondering...Is it possible to set up Push transactional replication from a SQL7 server (running the publisher and distributor) to a SQL2000 server (running the subscriber)? All this across a VPN and Firewall both sides.Thanks!MariaMaria BermudesDBALondon  |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-11 : 14:14:14
|
| Yes, you can do this across a VPN with two firewalls. How long it will take depends on your relationship with each side of the firewalls. SQL Server uses Port 1433 as a standard and UDP 1434 for Applications. You will also have to use Multi-Protocol (With TCP/IP enabled) or the recommended TCP/IP. It would probably be beneficial for you on each end to use the Client network utility and assign an alias for the opposing server with IP/Port in the Alias.Connection Params section. The Firewall/Network Admin will then have the firewall forward all requests to UDP 1434 and port 1433 (default) on that ip address. Connecting from one server to the next will come into play with the aliases you created. The replication piece shouldn't be an issue once the firewalls are talking. One thing you might want to consider though is how often your data needs refreshed and if you should use snapshot or transactional. I would probably suggest snapshot if you can get away with it or transaction depending on your bandwith and the data (how often it changes), but I would try and stay away from merge as re-synching over a large are can become a very cumbersome beast, Especially when it breaks.JMHO,JamesH |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-18 : 14:16:26
|
| Found a Q article you might be interested in:Q164667Hope this helps you.JamesH. |
|
|
|
|
|
|
Replication from SQL7-2000 ???