How can we help you today? How can we help you today?

SQL Compare 9: command line options not working

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
0

Comments

1 comment

Sort by
  • DarthJurious
    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
    0

Add comment

Please sign in to leave a comment.