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

jerstep

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?

DanC

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?