command for sql compare

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?

kagc August 14, 2020 16:08

Comments

1 comment

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
Tianjiao_Li August 18, 2020 13:22

0

Add comment

Please sign in to leave a comment.

How can we help you today?

command for sql compare

Comments

Add comment