| Author |
Message |
DarthJurious
Joined: 08 Nov 2012 Posts: 2
|
Posted: Thu Nov 08, 2012 9:27 pm Post subject: 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 |
|
| Back to top |
|
 |
DarthJurious
Joined: 08 Nov 2012 Posts: 2
|
Posted: Fri Nov 09, 2012 10:48 pm Post subject: |
|
|
| 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 |
|
 |
|
|
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