SQLServer 2012 Replication (using C#)

A

AmjiBhai

Joined
Feb 21, 2018
Messages
216
Reaction score
86
I have three laptops (A,B,C) each having identical local DataBase (S1)
My laptop is A and I connect remotely with B & C
I want to replicate S1 at laptops B & C on laptop A ...

I found this link http://www.nullskull.com/a/10474998/sql-server-replication-using-c.aspx...
It sounds good match of what I intend to do but I am lost in the terms (Publisher & Subscriber)

Shall I assume my laptop(A) as Publisher and the remaining two as Subscribers or what?

Thanks in advance.
 
Yes laptop A should be the Publisher, it will be the main copy. So you are using SQL Server 2012? And you want to use C# to handle the syncing of these different copies? This is the documentation about Replication: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms151198(v=sql.110)

It says you have a few options for synchronizing the databases. One is the Sync Framework: https://docs.microsoft.com/en-us/pr...k-2.1/bb726002(v=sql.110)?redirectedfrom=MSDN

This page describes all the Replication features and terminology: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/bb677158(v=sql.110)
 
Back
Top