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 |
|
frant101
Starting Member
12 Posts |
 Posted - 2009-01-09 : 08:14:11
|
| Hi there,I am looking for some help to a problem i have, I have one master database(publisher) with a satellite database (subscriber). I want to keep the satellite database up to date with any changes that happen in one table on the master database.I only want certain columns on the subscriber to be updated not the whole table. Currently both tables on the subsriber and publisher are identical.If i set up Transactional Replication and select only the columns i want to replicate the subscriber loses the columns that havent been selected for replication. I dont want this to happen though, although i dont want them updated from the publisher to the subscriber i still want them to be in the table and useable on the subsriber.When replication is initalised the columns that arent selected for replication are removed from the subsciber....any ideas how to get round thisThanksFrant101 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 09:21:08
|
| Are those databases in Same instances? |
 |
|
|
frant101
Starting Member
12 Posts |
Posted - 2009-01-09 : 09:54:23
|
| no they are on different instances, one is sql server standard 2005 the other is sql server express 2005 (the subscriber) |
|
|
|
sourvil
Starting Member
14 Posts |
Posted - 2009-01-13 : 07:25:32
|
| I think no. You don't have a choice.But another way; you can use Synchronization tables for Transaction Replication (having certain columns) and all these tables will have update triggers for real tables. Alsa you must create new triggers for real tables to update Sync. tables.Maybe this will be a solution? |
|
|
|
|
|
|
Wanting to Replicate only certain columns