Deploying the target database
We'll now deploy the data warehouse database that is called AdventureWorksLTDW2016
.
Getting ready
This recipe assumes that you have access to the sample solution that is available for this book and you have read and executed all the steps to deploy the source database.
How to do it...
The steps will be essentially similar to the ones used to deploy the source database. Since we explained most of the steps previously, this recipe will be more concise:
- The
DB.AdventureWorksDW
project contains the following schemas:Cube
: This contains specific database objects, mainly views that can be used by an SSAS cube.dbo
: This the default schema.DW
: This folder contains database objects that belong to theDW
schema, that is, the data warehouse star schema objects.Scripts
: This is a folder that holds pre or post-deployment scripts, as well as utility scripts.Staging
: This folder contains database objects used by theStaging
schema.SystemLog
: This folder contains database objects...