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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication between unconnected databases

Author  Topic 

karlman
Starting Member

11 Posts

Posted - 2009-11-25 : 14:11:24
Hello,

I have two SQL 2005 databases that cannot be connected together via any kind of networking connection. The only thing I can do is ferry files back and forth between the servers.

Is there a way to keep certain tables in both databases synchronized via files shipped back and forth? I realize it will not be real time which is fine. The fields updated on either side are always different so there will not be collissions.

I figure I can code this but I was hoping maybe something existed.

Thank you!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-25 : 14:19:18
You could use bcp.exe to move the data around.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -