Feature enquiry

Forum for users of SQL Compare schema synchronization utility

Feature enquiry

Postby oceandeep » Tue Apr 02, 2013 8:13 am


Before my purchase/trial I wish to clear my use case, I have a use case this:
1. A centralized SQL Server contains a Superset of some data
2. 10-15 clients SQL Server Express that need a Subset of such data
3. The client will create new data
4. Data of each side needed to be synchronized in every 5-10 mins

Can SQL Compare being use as the automatic sync service from a Superset to Subset (server to client) and vice versa (subset of client data increment to server)?
Posts: 2
Joined: Tue Apr 02, 2013 8:10 am

Postby eddie davis » Tue Apr 02, 2013 11:31 am

Hi Oceandeep

Thank you for your forum post.

Firstly, SQL Compare is not tool you need to evaluate, this would be SQL Data Compare. SQL Compare compares and deploys database objects, whilst SQL Data Compare can be used to compare and deploy data.

Secondly SQL Compare and SQL Data Compare are not alternatives to Microsoft's SQL Server Replication Technologies. From the sceanrio you have described, it appears that you need to implement SQL Server Merge Replication.

In theory using the Command line Interface of SQL Data Compare you configure SQL Data Compare to perform an automated deployment. From experience, the frequency you wish to synchronize is not feasible. A frequency of once or twice an hour maybe achieved and I would only recommend a one way deployment not the two way deployment you are seeking.

I recommend that you take a look at this Knowledge Base artilce using this LINK. The article was first published in September 2008 for SQL Data Compare V6 and V7, however the advice it contains is still valid for the latest V10.

SQL Compare and SQL Data Compare will help you deploy from the Superset server to each client in turn when you first configure the scenario you have described.

Please download and evaluate to see if it meets your need.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby oceandeep » Wed Apr 03, 2013 6:41 am

Thank you.

I will first head for the trial according to your advise.

Thanks a lot.
Posts: 2
Joined: Tue Apr 02, 2013 8:10 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest