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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 updating master DB from local DB...

Author  Topic 

hueby
Posting Yak Master

127 Posts

Posted - 2004-11-12 : 14:05:02
Hey all, Here is what I would like to do.. if any can give some advice or direction with this i would appreciate it.

We have a "master database" (MS SQL) at our main office. Then a smaller office with only a dial-up connection. Can I have my db application write all the data input to a local DB. Then write something to connect with the master DB, through a Terminal server, etc., and update it with the data from the other smaller db?
   

- Advertisement -