Command Line - compare and do not include identical
rre
Posts: 42 Bronze 2
Hello,
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.
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>
Comments
What I typically recommend is to wrap the command into a batch file where you can trap error code 63 and return 0 instead using EXIT /B like this:
http://www.red-gate.com/messageboard/vi ... hp?t=14969
What I typically recommend is to wrap the command into a batch file where you can trap error code 63 and return 0 instead using EXIT /B like this:
http://www.red-gate.com/messageboard/vi ... hp?t=14969
Do you think there will be a feature coming to avoid executing SQL Compare twice? Or do I have to do a feature request on the uservoice?