Demo, Data Warehouse V1
A Sample OLTP and OLAP/Data Warehouse DBs to demo how to build and load a Data Warehouse DB from OLTP DB.
-https://github.com/Afsarsoft/SQL101
-https://github.com/Afsarsoft/SQL-AnimalShelter
For OLTP DB
1- In a new or existing SQL DB or Azure SQL DB, from "Script1" folder, install script CreateSchema.sql
2- From "SP" folder install all SPs (ignore any warnings)
3- From "Script2" folder, run all scripts starting with 01_% to 03_%
For OLAP/Data Warehouse
1- In a new or existing SQL DB or Azure SQL DB, from "Script1DW" folder, install script CreateSchemaDW.sql
2- From "SPDW" folder install all SPs (ignore any warnings)
3- From "Script2DW" folder, run all scripts starting with 01_% and 02_%
1- Create a folder "C:\DDW1"
2- Copy folders "Script1", "Script2", "Script1DW", "Script2DW", "SP", AND "SPDW" to folder "C:\DDW1"
For OLTP DB
3- Change connection "OLTP_Connection" according to your environment and Run SSIS package BuildOLTP to install all SQL objects
For OLAP/Data Warehouse
4- Change connection "DW_Connection" according to your environment and Run SSIS package BuildDW to install all SQL objects
Change connections "OLTP_Connection" and "DW_Connection" according to your environment and Run SSIS package LoadDW to Load OLAP/Data Warehouse