Command line syntax question

spuleo

Hello,

I am working on an automation script that will perform a command line sqlcompare between a script folder (generated from sql version control) and a physical database. I am able to get everything working but I cannot figure out the command line syntax to prevent the sync from dropping objects from the target database that do not exist in the source.

In sqldatacompare you can do something like /include:missing /include:different and it will only do inserts and updates (no deletes). I am looking for the corollary in schema compare...

Thanks,
Scott++

James B

Thanks for your post.

You can use similar options in SQL Compare - see here

I think it would be /exclude:Additional you'd need to look at, which would ignore objects not present in the source.