6

I have C# windows form application and I have same database schema on both MS SQL Server(for master user) and on SQL Express(for clients). My database size is around 2 GB for each client.

I want to synchronize this databases once in a day. In MS SQL Server 2008 we have used RMO but RMO API deprecated in SQL Server 2012.

Is there any good suggestion or example then refer it. I am new to database operations so i don't have much idea bout this.

  • 1
    Do you want to synch them both ways or just whatever is on Master is going to the Client DB? – Bartosz X Aug 18 '17 at 12:54
  • sync both ways.. – Jaimesh Aug 18 '17 at 12:56
  • 1
    Have a look into this merge replication – Bartosz X Aug 18 '17 at 13:00
  • It's nice concept. But do you have any practical/code example? If any then plz refer. – Jaimesh Aug 21 '17 at 5:08
  • Please note accompanying question: stackoverflow.com/questions/45953445/… we are now at the point where merge replication is almost working – Nick.McDermaid Sep 4 '17 at 10:08
1

I fully expect down-votes on this, but deprecated doesn't mean discontinued. When a feature is deprecated it generally means that said feature won't be expanded and will likely be removed in a future release. According to MS documentation RMO doesn't show up under features that were discontinued in either SQL 2014 or SQL 2016, but again I wouldn't count on it being available going forward.

The point here is if you've already got something that works using RMO with SQL 2012, see if it works in 2014 and continue using it. No point to reinvent the wheel if you don't have to. Who knows, in 5-years-time you may no longer use this application, this back-end, or even this approach. It's also entirely possible that RMO could turn into something similar to the sysindexes view that was deprecated way back in SQL 2005 but is still in SQL 2017 by the looks of it.

In terms of an official "supported" approach, Merge Replication, as stated by Bartosz X in the comments is your best bet, based on what it sounds like you want to accomplish. Some additional searching on DBA.SE or Google should get you going.

  • is there any way to do merge replication on sql server express , without using sync framework. – Dragon Sep 7 '17 at 13:55
  • any thing like merge replication – Dragon Sep 7 '17 at 13:55
  • @Dragon I would recommend asking a new question about this instead as it'll generate a better amount of responses. – John Eisbrener Sep 7 '17 at 13:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.