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

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

jerstepjerstep Posts: 1 New member
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:

Answers

  • Options
    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?

Sign In or Register to comment.