Command Line Switch AddDatabaseUseStatement Not Working

Forum for users of SQL Compare schema synchronization utility

Command Line Switch AddDatabaseUseStatement Not Working

Postby CraigEddy » Thu Aug 01, 2013 6:12 pm

I've added this to the command line, but my script doesn't have the USE statement. Here's a snippet from the powershell script that executes my comparison:

sql_compare /Database1:FACTSInfo /Version1:Head /Database2:FACTSInfo /Server1:$sqlServer /Server2:$sqlServer /filter:$filterfile /options:IgnoreWhiteSpace,IgnoreFillFactor,AddDatabaseUseStatement /sync /scriptfile:deploy.sql /force

I'm comparing from SQL Source Control to a newly-restored copy of the database, which is why the same database name is used.

Any ideas?

Craig Eddy
Posts: 24
Joined: Fri Sep 28, 2012 1:59 pm

Postby Manfred.Castro » Mon Aug 05, 2013 5:11 pm

Thank you for reporting this.
I was able to reproduce the behavior you are describing and have logged a bug in our system under the internal reference number of SC-6479.
Sorry for any inconvenience this may have caused.
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 2 guests