CODEWITHSUNDEEP
sql-serverdatabasedatabase-mirroring
Ali Esfahani
Ali Esfahani

Reputation: 129

Database mirroring

I'm designing a CRM for a company with 3 branches. the connection between these 3 branches is not reliable (with a vpn over internet). so we decided to setup a local server with SqlServer Database in each one and configure these DBs in the way that whenever a client inserted data into any of these DBs it automatically insert it into other ones. How could I do this? and my programming language is C# if it would help!

Upvotes: 0

Views: 208

Answers (1)

podiluska
podiluska

Reputation: 51514

You could use SQL Server replication, more specifically Merge Replication

See http://technet.microsoft.com/en-us/library/ms152746.aspx

Upvotes: 1

Related Questions