Confused about include identical and scripting

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Confused about include identical and scripting

Postby freecell1 » Thu Mar 29, 2012 3:37 pm

I am trying to do the following:

1) Compare two databases via command line (automated).
2) If not identical, generate sync script.
3) If identical, do not create a script.

I hoped to be able to do this without getting error codes on identical databases, so I used include:identical. However that causes it to generate useless scripts when the databases are the same (lots of drop/add constraints etc). All I want is to suppress the error if they are the same, but not have an error occur.

This seems to not be possible. Do I have to write a console app to wrap the command line calls and ignore error 63?
freecell1
 
Posts: 21
Joined: Tue Mar 13, 2012 8:21 pm

Postby Brian Donahue » Mon Apr 02, 2012 11:31 am

You could wrap the command in a batch file and exit /B with return code 0, but if you are using 10.1, you can use the undocumented /assertidentical switch. Hopefully you have the latter option available! (if not, please run Check for Updates)
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron