how to send changes to other databases

[WyldGynjer]

I need a way to take changes made in one database (DB1) to be put in other databases (DB2 and DB3).

If I update, delete or add in DB1 then I want those changes to be put in DB2 and DB3. However, one table has 10 fields, I only want 5 of those fields to be sent to DB2 & DB3. If I update DB2 or DB3 I DO NOT want them to be put in DB1.

Is there a way to do this with Replication? Or should I use a DTS Script? I've tried to set up merge replication, and so far I've not done it correctly; is it possible to do what I want?

Suggestions?

 

[mrdenny]

Replication will do what you want. That is pretty much your only options other than writting your own replication using triggers, as log shipping will send the changes for all tables in the database.

When you setup replicaiton it will ask you what articles you want to publish. The articles are the tables. Just select the 5 you want, then setup the subscribers to push or pull the subscription.

Denny

--Anything is possible. All it takes is a little research. (Me)