A set up using docker services to extract and query AdventureWorks database provided for learning purpose by Microsoft.
- First service extracts and downloads database backup file.
- Second service sets up MS SQL Server in docker container and loads the backup file.
- Third service makes a connection to SQL Server using
pymssqllibrary. It restores a database and queries 3 example writing them out to csv files for inspection.
Requirements: Docker and docker compose
Once repo is cloned:
docker-compose up --build