Command Line - compare and do not include identical
we are using the command line tool of SQL Compare and I want to archive to get a comparison report in conjunction with the script file and not including the identical objects into the comparison report.
Currently I have to specify all the time the switch include:identical to avoid the exit code 63. So far so good. In the relase notes for 10.4 I read that with the ticket SC-6165 it is fixed.
For me it's still the case. I doing something wrong?
Basically SQL Compare should exit without an error and show me only the differences in the comparison report? Identical objects should be excluded from the report.
May be the switch /assertidentical could help me. But unfortunately it tells me that I can't used it together with the scriptfile parameter.
For doing so I am using the XML file feature.
<?xml version="1.0" encoding="utf-8"?> <commandline> <scripts1>snapshot</scripts1> <server2>.</server2> <database2>MyDatabase</database2> <exclude>Role</exclude> <exclude>User</exclude> <!-- avoid getting error number 63 (Databases identical) --> <include>identical</include> <options>IgnoreWhiteSpace,IgnoreDatabaseAndServerName,IgnoreWithElementOrder,IgnoreUserProperties</options> <scriptfile>C:\solutions\logs\MyDatabase\UpdateDbStructure.sql</scriptfile> <report>C:\solutions\logs\MyDatabase\UpdateDbStructure.html</report> <reporttype>Interactive</reporttype> </commandline>