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?