Red Gate forums :: View topic - Feature enquiry
Return to www.red-gate.com RSS Feed Available

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

Feature enquiry

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
oceandeep



Joined: 02 Apr 2013
Posts: 2

PostPosted: Tue Apr 02, 2013 9:13 am    Post subject: Feature enquiry Reply with quote

Hi,

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)?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Tue Apr 02, 2013 12:31 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
oceandeep



Joined: 02 Apr 2013
Posts: 2

PostPosted: Wed Apr 03, 2013 7:41 am    Post subject: Reply with quote

Thank you.

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

Thanks a lot.
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