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

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

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?

Answers

Sign In or Register to comment.