Generated migration script doesn't include statement to create a new schema

tigmars

I did this in 2 different databases, each of which has its own SCA project:

CREATE SCHEMA foo

CREATE TABLE foo.bar(id INT)

In one project, SCA generated statements to create foo and also to create foo.bar.  In the other, SCA generated only the statement to create foo.bar.  Then creating the shadow database fails;  it can't create foo.bar because foo doesn't exist.

Is there a setting in .sqlproj that I messed up?  Anyone know what I do so that SCA generates both CREATE statements?

DanC

Hi @tigmars

I'm going to reach out via a support ticket to investigate this further!