command for sql compare

kagc

Hi,

I want to use dos command to do a sql compare from a sql server to a new scripts folder, and then save the scripts to the folder. Can someone provide me with a command example?

Tianjiao_Li

You could make an empty folder 'WidgetProductionScripts' and then do

sqlcompare /Database1:WidgetStaging /Scripts2:"C:\WidgetProductionScripts" /Synchronize /Force

https://documentation.red-gate.com/sc/using-the-command-line/simple-examples-using-the-command-line

or creates a scripts folder from the data source directly:

sqlcompare /db1:WidgetStaging /makeScripts:<span>"C:\Scripts Folders\Widget staging scripts"</span>

https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/MakeScripts:%3Cfolder%3E