Activity overview
Latest activity by paulbarbin
Thanks Michelle. I've already coded around the problem in my batch file. But that is good to know. / comments
Thanks Michelle. I've already coded around the problem in my batch file. But that is good to know.
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.
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
compared.
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. / comments
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.
Exit Codes
==========
0 - Success.
1 - General error...
Sql Compare Exit Codes or ErrorLevel
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 t...
I really hate to admit this, but I didn't realize there WAS an API. Thank you for the suggestion. I will definitely look into that! / comments
I really hate to admit this, but I didn't realize there WAS an API. Thank you for the suggestion. I will definitely look into that!
Create vs Alter in Sync Wizard
When creating sync scripts, is it possible to have the wizard generate "if exists, drop and create" vs an alter?
Its not common, but every once in a while we have an object missing from one client'...
Disabled Triggers not synchronizing properly
I have some triggers that exist on one database that do not exist on the other however when they are added to the new db, they are disabled. This is an automated process based on data in the db. ...