command line project and synchronize switch

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

command line project and synchronize switch

Postby shuff » Thu Dec 01, 2011 8:46 pm

When using the command line project and synchronize switch -- you get the message "Generating SQL scripts" ..... where does this script get generated? I know if I do it via the interface the script goes into My Documents\\SQL Data Compare\\SQL Scripts .... but I don't see it via the command line. I want to make sure the script gets deleted because it's HUGE. Thanks.
shuff
 
Posts: 17
Joined: Mon Nov 26, 2007 8:50 pm

Postby james.billings » Thu Dec 01, 2011 9:27 pm

Hi,

The script in the GUI is only saved when you actually save it, and the path you mention is the default location.
When using the command-line you use the /ScriptFile switch to specify the path/filename to save.
You can also use the /sync switch to synchronise the changes directly; but it should remove any temporary files afterwards.

See here for details on switches: http://www.red-gate.com/supportcenter/Content/SQL_Data_Compare/help/9.0/SDC_CL_Switches

If you want to specify a bigger drive for temp files, you can create an environment variable called RGTEMP and set that to the path you wish to use.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests