SQL Compare 9: command line options not working
DarthJurious
Posts: 3
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
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
Comments