Hi 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.
Tell me more
×
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. It's 100% free, no registration required.
|
|
|
Sync Framework is designed explicitly to synchronize occasionally connected data sets. |
|||
|
|
|
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. |
|||
|
|
|
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. |
|||
|
|
