December 9, 2013 at 8:28 am
Hello, im new in this forum and I have a question.
I have 2 different instances of sql server 2008 r2 in 2 different locations, both intances have a database with different data but I need to have the same data of some tables in each instance,
instance a
table a, b, c, d, e
intance b
table a, b, c, d, e
I need the tables a, b mirroed in both instances and the rest of them stay as they are meaning that when someone insert, delete or update in instance b->table a it will be reflected in instance a->table a and the same if the modification is made in instance a
Sorry for my english I hope you guys understand me :pinch:
December 9, 2013 at 8:36 am
In this case the ideal IMO would be merge replication or peer to peer replication.
Both would allow data modifications on either instance.
December 9, 2013 at 9:06 am
tyvm ill google that 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply