CODEWITHSUNDEEP
sqlprojqbo3
Eric Patrick
Eric Patrick

Reputation: 2247

QBO3 database deployment does not create Entity view

When deploying a database theme to create a new QBO3 database, the Entity view was not created.

My theme includes references to the following .sqlproj projects:

And I see that the Standard.sqlproj > Scripts > Script.PostDeployment.sql includes creation of an Entity view if it does not already exist.

Do I need to deploy each project separately?

Upvotes: 1

Views: 32

Answers (1)

Eric Patrick
Eric Patrick

Reputation: 2247

To include pre-and-post deployment scripts from "core" projects, modify your theme's pre-and-post deployment script to include the relevent scripts from the other projects.

For example:

:r ..\..\Standard\Scripts\Script.PostDeployment.sql
:r ..\..\Mortgage\Scripts\Mortgage.PostDeployment.sql

Note that the :r syntax is a SQLCMD convention to include external files. The included files will be run in the order in which they are included.

Upvotes: 1

Related Questions