QBO3 database deployment does not create Entity view

Question

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:

Standard
Mortgage
Credit
Debt

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?

Eric Patrick · Accepted Answer · 2017-10-12 12:00:19Z

1

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.

answered Oct 12, 2017 at 12:00

Eric Patrick

2,3072 gold badges24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

QBO3 database deployment does not create Entity view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related