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 |
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 advanceSatish" |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-30 : 04:31:03
|
Investigate triggersorReplication. |
 |
|
|
|
|