A Sample Data Warehouse/OLAP for Game 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
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 LoadGameDW
Note: SSIS package LoadGameDW load data from "OLTP" environment to the "DW" environment.
1- Create a folder "C:\GameDW"
2- Copy folders "Script1", "Script2", "SP" in folder "C:\GameDW"
3- For SQL DB or Azure SQL DB, change connection "DB_Connection" according to your environment and Run SSIS package BuildGameDW
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 LoadGameDW
Note: SSIS package LoadGameDW load data from "OLTP" environment to the "DW" environment.