Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for an alternative of merge replication that work without internet connection, something like red gate sql data compare but not in uniq direction.

share|improve this question

closed as off-topic by bluefeet, RolandoMySQLDBA, Mark Storey-Smith, billinkc, Kin Dec 16 '13 at 19:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – bluefeet, RolandoMySQLDBA, Mark Storey-Smith, billinkc, Kin
If this question can be reworded to fit the rules in the help center, please edit the question.

Sync Framework is designed explicitly to synchronize occasionally connected data sets.

share|improve this answer

You will need to do something like utilize Change Data Capture but you will need to roll your own sql statements.

I'm confused why Merge Replication won't work for you here. If you set the retention period high enough, it can go disconnected and pick up where it left off once connected again.

share|improve this answer

You can setup the merge replication to work with your network disconnects. To get the functionality of the data compare, try using Interactive Conflict Resolution. This way you can determine the outcome of your conflicts.

share|improve this answer

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