Red Gate forums :: View topic - Confused about include identical and scripting
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Confused about include identical and scripting

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
freecell1



Joined: 13 Mar 2012
Posts: 20

PostPosted: Thu Mar 29, 2012 3:37 pm    Post subject: Confused about include identical and scripting Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Apr 02, 2012 11:31 am    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group