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 |
|
jamonakes
Starting Member
18 Posts |
 Posted - 2007-12-15 : 18:04:13
|
| I am designing a system which depends on a database thousands of miles away (herein referred to as the Master DB). The Master DB will be getting updated round the clock. The database for the system I am designing (Slave DB) rests on a totally different network from the Master DB. Is there a way I can have the Master DB effect any CRUD changes as soon as they happen, in real time i.e., to the Slave DB? E.g. If a record is inserted in a table in the Master DB, it immediately fires a trigger (or whatever else) that inserts into/updates the Slave DB (thousands of miles away) with the change that was effected in the Master DB. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
jamonakes
Starting Member
18 Posts |
Posted - 2007-12-15 : 18:38:18
|
| Thanks spirit1, let me read it and see if I can make heads or tails out of it. jamonakes |
 |
|
|
|
|
|
Help with real time data transfer