I am using the command line version of SqlCompare (version 5!) and I'm looking for a list of the exit codes or DOS ErrorLevels to expect. I'm calling the compare from a DOS batch file and I want to know what codes will give me sucess vs failure.
I've seen reference to 63 being databases are equal, but I would have thought that would be error 0. I am currently getting an error 9009 and that happens when the db that we're comparing doesn't exist.
If I need to upgrade to 6 or 7 in order to get exit codes, I'd be willing.
Ok, ignore the error 9009 - that was because the batch couldn't find the sqlcompare exe. I ran sqlcompare /verbose /? and found the exit codes.
0 - Success.
1 - General error code.
3 - Illegal argument duplication. Some arguments may not appear more than once in a
command-line. If such arguments appear more than once this exit code will be returned.
8 - Unsatisfied argument dependency or violated exclusion when user runs command line. E.g.
/arg2 depends on /arg1 but you have specified /arg2 without specifying /arg1, or
alternatively /arg2 cannot be used with /arg1 but you have tried to use them both.
32 - Value out of range. Numeric value supplied for an argument that is outside the range of
valid values for that argument.
33 - Value overflow. The magnitude of a value supplied for an argument is too large and causes an overflow.
34 - Invalid value. The value supplied for an argument is invalid.
35 - No / invalid software license or trial period has expired.
63 - The databases being compared are identical with respect to any constraints on objects being
64 - General command-line usage error.
65 - Data error. Some input data required by the tool is invalid or corrupt.
69 - A resource or service required to run the tool is unavailable.
73 - Failed to create report
74 - IO error occurred. Generally returned if the program attempts to write to a file that
already exists without the user having specified the /force option.
77 - Action cannot be completed because the user does not have permission.
126 - Execution failed because of an error.
130 - Execution stopped because Ctrl+Break.