Data Sync between more than two SQL Server

Basit Khan

8y931

Hi,

I have more than one SQL servers with same data schema/structure. One main server which online 24x7. others servers are locally installed on each client.

how to get the server will sync with main server.

manually its possible becoz in my every transaction table have primary keyno and location no, with this i can able to transfer data from server to client and client to servers.

server will transfer master data to the client and client will send the transaction data to the server with the help of primary key of table and location number with the help of xml import/export data manually.

But how to sync the clients to the server when internet connection available in client machine.

i googled it, and i found sql server replication, but i don't know how the sql server replecate primary key and location number in servers and client database.

becoz each client will generate same primary key only with the location no will get difference.

please help on this.

Thanks

Basit.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
We can not give you a simple answer because they are lots and lots of factors that we must know before we can offer you a solution

but I feel that (I may be wrong) you need to do more investigation on the variety of solutions provided by Microsoft

please check

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/replication/types-of-replication
Amit Gupta8y ago
Hey Basist

Actually, I had done some research on the same in past months for syncing the database.

I had tested with 2 servers, it might be available for multiple servers.

You can do this using MS Sync Framework
https://msdn.microsoft.com/en-us/library/mt763484.aspx