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)
 Database syncronization.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-30 : 00:00:36
Satish writes "Hi,
This is related to keep the data on 2-different SQL servers Synchronous.
Here, we have 2-SQL servers and on each server there is database called 'TESTDB' and having 5-6 tables. The access of the data base differes application userwise. But we want to maintain the database update on both the servers.
e.g suppose user inserted one record in 'serverA' database then same record should be inserted in another database server 'ServerB'.

Plz. revert ASAP.

Thanks in advance

Satish"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-11-30 : 04:31:03
Investigate triggers
or
Replication.
Go to Top of Page
   

- Advertisement -