This setp starts a Microsoft Server 2019 Docker container and imports the data source for subsequent DataWarehousing exercises.
- Docker must be installed and running on your machine.
git clone https://github.com/tinzog/DataWarehousing.git
cd DataWarehousingExercisesRun Make Command: Execute the following command to set up the SQL Server instance with the Demo databases:
make init-allRun Bash Script:
bash setup.batIf you encounter problems when executing the scripts, please try to run the steps (pull-image, run-container, set-backup,restore-db) separately.
You should now have a MSQL Server instance running in a Docker container with the data source required for our exercises.
NOTE: the container including the database is removed when you run the init script again. In order to reuse the existing container use docker start SQL19 or docker stop SQL19.
Use your favourite db client to connect to the SQL Server. It must be able to handle MSQL Server connections, e.g.:
- SQL Server Management Studio (SSMS) (Windows only)
- DBeaver (all platforms)
- SQLPro for MSSQL (Mac only)
- DB Gate (all platforms)
- Username:
SA - Password:
Password+123 - Port:
1433 - Host:
localhost
Schema visualisation: https://dataedo.com/samples/html/AdventureWorks/doc/AdventureWorks_2/home.html
Backup files: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
Usages: https://jise.org/Volume26/n3/JISEv26n3p177.pdf
This repo was initially a fork from https://github.com/SimonStride/AdventureWorksInDocker. The setup has then been adjusted based on the following turorials: