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.

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

1 Answer 1

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.

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

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.