How do I ensure dependencies are correct using SQL Compare script generation?

jerstepjerstep Posts: 1 New member
in SQL Compare
I have created a script of a database but on deployment I'm getting lots of errors as object dependencies are not being created in the correct order i.e. user defined types being created after the tables that use them, tables created after views that reference them. Could someone explain what I'm doing wrong?
Tagged:
· Share on Twitter

Answers

  • DanCDanC Posts: 637 Gold 5
    Hi @jerstep,

    I'm sorry you're experiencing this issue!

    The tool should certainly be taking these dependencies into consideration and if it's not the case this would certainly be a bug.

    Could I first ask what version of SQL Compare you're using?

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our     Help Center?

    · Share on Twitter
Sign In or Register to comment.