I have three MS SQL Server databases named them like DB1,DB2 and DB3
I like to do this
DB1 and DB2 synchronize each other like if any change made in db1 it will upload at db2 if there is any change in db2 it will update in db1 this should be immediate updates.
This is two way replication how it will.
my other task is that i like to just update data changes in db2 to db3 all of these dbs are on static ips.
i have tried with database replication it is working fine with only one side replication explain (DB1 replicated with DB2 immediately update database changes to db2), while when i trying to replicate database between db2 to db1 it gives me error replication can not work because db1 is using in data replication how can i do two way replication.
which tool Replication i have tried it, it only work with one side, not working with both side replication means db1 can replicate with db2 while if i replicate db2 with db1 it gives me error db1 is not updated because tables or table name already replicated with other db please help in this.