Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Red Gate data compare Automate??? Expand / Collapse
Posted Sunday, April 11, 2010 9:06 PM


Group: General Forum Members
Last Login: Monday, October 17, 2016 3:06 AM
Points: 182, Visits: 635
can we automate the redgate data compare for synchronizing the data from back up file to database on a server and schedule it for daily purpose ..?
if some one can guide me....please let me know ..
Thanks in advance ....

Post #901335
Posted Monday, April 12, 2010 4:07 AM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 17, 2015 9:22 AM
Points: 1,097, Visits: 1,336
I dont believe this is possible. The compare program is greate but the functionality of what you can get it to do is quite basic.

Having said that, if there are any SQL Compare Developers/Gurus out there who can make it possible PLEEEEEEEEASE

Adam Zacks


Be Nice, Or Leave
Post #901440
Posted Wednesday, April 14, 2010 4:38 AM


Group: General Forum Members
Last Login: Tuesday, September 25, 2012 8:13 AM
Points: 11, Visits: 321
Hi there,

This is indeed possible, depending on what version of SQL Data Compare you have. I believe this should be supported with version 6 and later (currently on 8) and if you have the PRO version of the tool.

The syntax (with version 8) for using a backup as the source and a DB as the target, and then performing a complete synch would look something like:

sqldatacompare /b1:"FULL_SQL2008_AdventureWorks2008_20100414_000000.sqb" /s2:"pete\sql2008" /db2:"AdventureWorks2008" /synch

If however you download a trial from the Red Gate site, open up CMD and run sqldatacompare /? /verbose this should then output a full list of switches to the console for you. With regards to the automation, once you have saved these commands as a batch file you can then set the file up to run with Task Scheduler.



*disclaimer: I work in the Support team at Red Gate
Post #902989
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse