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 |
|
eeckberg
Starting Member
1 Post |
 Posted - 2005-11-11 : 08:32:49
|
| I have a client with two SQL Servers, one on each side of their firewall. Some of the data tables will be read-only to the internet world, so any record added or modified can be pushed to the outside world by a trigger, right? The other is a set of tables that can be modified by web users as well as company users. Should I use a trigger on both servers to update each other or can a replication job maintain the synchronization of just a few tables, not the entire database?Thanks,Eric |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-11-11 : 15:24:52
|
| replication can do thatbut if you havent done sql replication before, i'd get a real dba in. especially if a client (and not your employer) is paying you for this |
 |
|
|
|
|
|
Replication and bi-directional updating