What are the challenges you face when working across database platforms? Take the survey

Ignoring Dependencies From Command Line

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?



  • Options
    Anu DAnu D Posts: 876 Silver 3
    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!
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.