create deployment script from CMD with compare

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

create deployment script from CMD with compare

Postby Kirby1367 » Mon Nov 19, 2012 4:56 pm

I am attempting to create a deployment script via CMD for SQL Compare. I have been unsuccessful at finding an answer though.

The end goal is to not sync the DB's via the command, but rather generate the deployment script itself like you can in the UI. CMD errors and says that /MakeScripts can not be used with the command /db2 though.

Is there another option I am overlooking?

This is what I was trying.
sqlcompare /db1:Shell_DB /db2:TargetDB /EXCLUDE:Certificate /EXCLUDE:Assembly /MakeScripts:"C:\\SQLFileMerge"
Kirby1367
 
Posts: 3
Joined: Wed Aug 01, 2012 4:42 pm

Found it

Postby Kirby1367 » Mon Nov 19, 2012 6:05 pm

Found out how. Was /ScriptFile instead of /MakeScripts
Kirby1367
 
Posts: 3
Joined: Wed Aug 01, 2012 4:42 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest