A Sample Data Warehouse/OLAP for Zagros OLTP Sample.
-https://github.com/Afsarsoft/SQL101
-https://github.com/Afsarsoft/SQL-AnimalShelter
-https://github.com/Afsarsoft/SQL-DDW1
-https://github.com/Afsarsoft/SQL-DDW2
-https://github.com/Afsarsoft/SQL-Game
-https://github.com/Afsarsoft/SQL-GameDW
-https://github.com/Afsarsoft/SQL-Zagros
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 02_%
4- For SQL DB or Azure SQL DB, change connection "DW_Connection" according to your "DW" environment change connection "OLTP_Connection" according to your "OLTP" environment and Run SSIS package LoadZagrosDW
Note: SSIS package LoadZagrosDW load data from "OLTP" environment to the "DW" environment.
1- Create a folder "C:\ZagrosDW"
2- Copy folders "Script1", "Script2", "SP" in folder "C:\ZagrosDW"
3- For SQL DB or Azure SQL DB, change connection "DB_Connection" according to your environment and Run SSIS package BuildZagrosDW
4- For SQL DB or Azure SQL DB, change connection "DW_Connection" according to your "DW" environment change connection "OLTP_Connection" according to your "OLTP" environment and Run SSIS package LoadZagrosDW
Note: SSIS package LoadZagrosDW load data from "OLTP" environment to the "DW" environment.