SQL Compare 9: command line options not working

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

SQL Compare 9: command line options not working

Postby DarthJurious » Thu Nov 08, 2012 9:27 pm

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
DarthJurious
 
Posts: 2
Joined: Thu Nov 08, 2012 8:12 pm

Postby DarthJurious » Fri Nov 09, 2012 10:48 pm

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.
DarthJurious
 
Posts: 2
Joined: Thu Nov 08, 2012 8:12 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests