Red Gate forums :: View topic - SQL Compare 9: command line options not working
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

SQL Compare 9: command line options not working

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
DarthJurious



Joined: 08 Nov 2012
Posts: 2

PostPosted: Thu Nov 08, 2012 9:27 pm    Post subject: SQL Compare 9: command line options not working Reply with quote

I'm using SQL Compare 9 to compare databases & the options I've specified seem to be not working. Syntax used is below. The report generates just fine, however, tables with "NOT FOR REPLICATION" on the identity column of tables in the second database are showing up as different. Any help would be greatly appreciated.

Syntax:
"F:\Program Files (x86)\Red Gate\SQL Compare 9\sqlcompare.exe" /snapshot1:"..\SNP.snp" /Server2:SVR\INST /database2:"DB" /options:Default,IgnorePermissions,IgnoreUsersPermissionsAndRoleMemberships,IgnoreStatistics,IgnoreWithNocheck,IgnoreQuotedIdentifiersAndAnsiNullSettings,IgnoreReplicationTriggers,IgnoreNotForReplication,IgnoreSchemaObjectAuthorization /filter:"..\FILTER.scpf" /quiet /report:"..\Reports\SVR$INST.DB".htm /rt:Interactive /force
Back to top
View user's profile Send private message
DarthJurious



Joined: 08 Nov 2012
Posts: 2

PostPosted: Fri Nov 09, 2012 10:48 pm    Post subject: Reply with quote

I finally figured this out (using the "try random stuff" method). You have to "quote" the options, once I did that they all worked perfectly.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group