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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-05-20 : 03:58:02
|
| There are five tables in db(1) on Server A. These five tables have to be replicated on to the production db(2) on Server B. I am thinking of Transactional replication to do this,but only for four of the tables. One of the tables is replicated on to db(dummy) on Server B. This is done,so that the columns could be mapped between the table in dbdummy and db2 on server B. so,how can we use a update trigger to update data between db(dummy) and db2 on Server B????????? Any suggestions on the complete process is well.Thanks in advance... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Trigger for databases