How do I ensure dependencies are correct using SQL Compare script generation?
jerstep 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?
0 · Share on Twitter
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?
Dan Calver | Redgate Software
Have you visited our Help Center?