SQLServer 2012 Replication (using C#)

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.
 

Abraham Andres Luna

Child of God
Joined
Mar 14, 2018
Messages
699
Reaction score
227
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top