Creating a single large deployment script via commandline..

mihird

Hello guys!

Newbie here, so pardon me, if I am asking something very simple, but I am just starting to get familiar with SQL Compare.

I went down the path trying to figure out, how to export a database to a single SQL schema file. By setting up a compare between the db to be exported and a blank instance, in the Deployment Wizard, I was able to pick "Create a Deployment Script" and noticed that it exports the entire db out in a single schema file.

Great! now, I want to do this on the command line...

I read the command line documentation and the /MakeScripts switch will do something similar, but it exports the db as a set of script files/folders instead of creating one single deplyment script.

Can someone help me figuring out how to make SQLCompare create this single deployment script for the db from the command line?

Thanks for your help!

Mihir

Eddie D

Thank you for your forum post.

I suspect that you have chosen the incorrect option. The "/MakeScripts" creates a scripts folder which is the equilvant to the option in the GUI ->File Menu ->Create Scripts Folder.

The switch you need to use to mimic the Deployment Wizard behaviour of creating the deployment script is "/ScriptFile" as per this simple example:

sqlcompare /db1:WidgetStaging /db2:WidgetProduction /scriptFile:"C:\Scripts Folder\WidgetSyncScript.sql" /force

Further reading on the available switches can be found HERE.

Many Thanks
Eddie

mihird

Yep,

That worked like a charm! Thanks for the help and the referral on the command line switches. Lots of learning to do for a newbie!

So far, very impressed with SQL Compare.
Mihir.