A Sample OLTP database for fictional Game production company.
-https://github.com/Afsarsoft/SQL101
-https://github.com/Afsarsoft/SQL-AnimalShelter
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 04_%
4- From "View" folder, run all scripts
1- Create a folder "C:\game"
2- Copy folders "Script1", "Script2", "SP", "View", and "CSV" in folder "C:\game"
3- For SQL DB or Azure SQL DB, change connection "DB_Connection" according to your environment and Run SSIS package BuildGame