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 |
|
Kypreos
Starting Member
1 Post |
 Posted - 2009-12-08 : 11:46:19
|
| Hello,I have a unique situation here. I have 2 SQL servers in 2 different geogrpahical locations. ServerA can communicate with ServerB, but ServerB cannot access ServerA's network and therefore cannot communicate with ServerA.Because of this I cannot setup transactional replication as ServerB can't pull any information from ServerA.Someone suggested using an SSIS package to push the changes to ServerA from ServerB. I can't seem to find any information on this.Can anyone point me in the right direction?Thanks. |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2009-12-18 : 14:38:48
|
| I set up transactional replication across domains. Microsoft has a paper on it. I think I needed to use a Windows account on each server with the same name & password.I think if you used SSIS, you'd need to create your own logic for identifying changes (ADD, DELETE, INSERT) and pushing them to the other server. I did that once for a specific application and it was a lot of work. |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
|
|
|
|
|
Replication between sites