cmdline no option "Add database use ..."

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_

jostorero May 07, 2009 05:19

Comments

3 comments

You can use the 'AddDatabaseUseStatement' option:

/options:Default,AddDatabaseUseStatement

Simon C May 07, 2009 05:27

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

Jerome

jostorero May 07, 2009 05:35

0
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.

RogerHart May 07, 2009 07:14

0

Add comment

Please sign in to leave a comment.

How can we help you today?

cmdline no option &quot;Add database use ...&quot;

Comments