cmdline no option "Add database use ..."

jostorero

Hi,

While comparing with cmdline, is there a way to generate change scripts with the sql command use [DB] at the top of the script ?

Thanks for your help

Jerome


My cmd is :
"sqlcompare.exe" /snapshot1:"a.snp" /snapshot2:"b.snp" /scriptfile:"c.sql" /out:"d.log" /f /o:f,d /exclude:User /exclude:Role /exclude:StoredProcedure:ExecRulesOfGroup* /exclude:StoredProcedure:getCallerInfo /exclude:Table:EPR_* /exclude:Table:_DYN_

Simon C

You can use the 'AddDatabaseUseStatement' option:

/options:Default,AddDatabaseUseStatement

jostorero

Ok thanks, I suggest to update the online doc :
http://www.red-gate.com/supportcenter/C ... 547562.htm

Jerome

RogerHart

Thanks for spotting that. We're doing a bit of work on SQL Compare soon, so I'll make sure it gets added to the documentation.