Partial Replica Synchronization for MS SQL Server

I need a means to create a SQL Server Express partial replica of a SQL Server 2014 server database and then synchronize the two, triggered by a C# command.  Eventually, there could be as many as a hundred partial replicas on various clients.  Anyone know how I can do this and where I should look to learn how to do it?  Thanks!
humbleamateurAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server has a native feature called Replication that allows to replicate data and objects from one database to another or more databases. The more simple is to chose the objects (articles) you want to be replicated from the source database (Publisher) to the target(s) database(s) (Subscribers). Then you can go to more complex replications like filtering columns and data.

Replication can be a world so I'll guide to a good starting point that is the BOL. Here's the Replication topic.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Partial replica? Only some data or only some objects? Or both?
You can use native Replication from SQL Server and then you won't need a trigger in C#.
0
 
humbleamateurAuthor Commented:
Some data.

I don't really follow your suggestion.  Can you provide more detail?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.