I have situation where my both servers need to be replicating with each other through transactional replication.
DB1-->Col1, Col2 replicate to DB2 --> Col1, Col2 through Transactional replication.By above scenario, changes in DB1 database replicate data to DB2 database.
Now, i want reverse of this to be executed.
In brief, When any user made change, insert or delete in DB2-->col1 and col2.
Then, this should be transfer to DB1.
Please advice, it is possible to implement this through triggers at DB2.Both of the databases are in use.
- Edited by Somesh Monga Thursday, September 13, 2012 5:50 AM
Thanks Olaf for suggestion,
I am aware about Merge Replication, But was thinking to utilize transnational replication and create triggers which will act as reverse of replication.
Is it possible to implement triggers for reverse replication and to avoid the duplicate entries to be inserted in any table.
I also forgot to mention that, I'm working on SQL Server 2000 Platform
- Edited by Somesh Monga Thursday, September 13, 2012 6:17 AM
Use bi-directional transactional replication. Follow these guidelines.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed as answer by Shulei ChenModerator Thursday, September 20, 2012 2:30 AM
Thanks Cotter for Link.
Please confirm if we can get same functionality(bi-directional ) with the help of Triggers.
Because, we have replication process going on servers but we are thinking to remove it and place triggers for same functionality.