Data compare replacing merge replication?

Forum for users of SQL Compare schema synchronization utility

Data compare replacing merge replication?

Postby Peter jones » Wed Nov 23, 2011 9:27 am

We want to use sql azure but need merge replication with one publisher and about 10 subscribers. Each subscriber would merge twice a day at most and there is no way of scheduling when a subscriber synchronises.

Is data compare a posible solution for our requirements?

Tia peter
Peter jones
Posts: 1
Joined: Wed Nov 23, 2011 9:18 am

Postby james.billings » Fri Nov 25, 2011 11:18 am

Thanks for your post.

Merge replication isn't something that Data Compare is really designed for unfortunately, as it's a one way process. In addition, Data Compare works by scanning through the whole DB to establish the changes required, then building a syncscript. When working with Azure and running it regularly, this is likely to add up to quite a cost where data transfers are concerned.

Azure does have its own Data Sync tool now (see here which may be worth looking into. I believe it adds triggers to the databases at each end and thus works more like traditional replication than a "scheduled sync".

Hope that helps!
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests