Data compare replacing merge replication?

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Data compare replacing merge replication?

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

Hi,
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 10:18 am

Postby james.billings » Fri Nov 25, 2011 12:18 pm

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!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests