Red Gate forums :: View topic - Data compare replacing merge replication?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Data compare replacing merge replication?

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Peter jones



Joined: 23 Nov 2011
Posts: 1

PostPosted: Wed Nov 23, 2011 10:27 am    Post subject: Data compare replacing merge replication? Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Fri Nov 25, 2011 12:18 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group