Ignoring Dependencies From Command Line

silverbackape

Hey All,

Is there a way to ignore dependencies while running sql compare from the command line?

My issue is, while deploying the sync sql, there are times when something like a trigger is a dependency and its creation is executed before the table it needs has been created on the target server. In this case the script will error and automation stops.

So I'm trying to disable dependencies so I can create all the tables without getting errors due to the order of creation.

If there is no way to ignore dependencies from the command line then is there a way to dictate the order of creation in the generated script?

Thanks

Anu D

Hi silverbackape,

Thanks for your post!

So IncludeDependencies is a default option used by SQL Compare. If you don't enter any options I would say specify /options:none or specify /options:and your options except default and specify the other default options one by one. More about it here.

Please let me know if this helps!