A sample SQL OLTP database for a fictional travel agency.
1-https://github.com/Afsarsoft/SQL101
2-https://github.com/Afsarsoft/SQL-AnimalShelter
3-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 09_%
4- From "View" folder install all Views
1- Create a folder "C:\zagros"
2- Copy folders "Script1", "Script2", "SP", and "View" in folder "C:\zagros"
3- For SQL DB, change connection "DB_Connection" according to your environment and Run SSIS package ZagrosBuild