sqlcompare.exe - exit code of 63 when databases are equal

Brian Donahue

Hi James,

Thanks for your comments. I believe that having a return code that tells the user that there are no database differences is necessary for a batch file to prevent unnecessary running of SQL scripts that contain no changes to the database, for instance.

JonathanWatts

Hi James,

You might be able to get around this by querying the %ERRORLEVEL% environment variable using the

string environment::get-variable(name)

function in NAnt. This can be used within conditional expressions.

Documentation for this function in the current release of NAnt is available at http://nant.sourceforge.net/release/latest/help/functions/environment.get-variable.html