Schema Compare

I just upgraded from Standard to Professional and went to use the Schema Compare feature for the first time. No issues with the basic comparison (i.e. it found all the differences) but I quickly noticed that the resulting script didn't take into account object dependencies. Did I miss a setting or does the generated script not take into account the order that scripts need to be created?

Which database types did you compare?

In this particular instance it was Views and Functions. One function was dependent on a view and one view was dependent on another view.

I meant to ask what type of the database. Is that Postgres or SQL Server or something else? The dependencies analysis is based to a large degree on the database system's dependencies view if such a view is provided. We look at the system dependencies first, then we apply this order - databases and other high level objects, then schemas, then tables, then functions and procedures, then views and materialized views, then everything else. From your description it sounds like your case was the oppositive, you had a function dependent on a view and needing a view created first.

I'm using SQL Server 2019. And, yes, I had a Function dependent on a View. And a View dependent on a different View.