chriseaton/adventureworks repository overview

⁠Docker AdventureWorks

This project is available on...

• Docker Hub: chriseaton/adventureworks⁠
• GitHub: chriseaton/docker-adventureworks⁠

⁠Tags & Support

Currently this docker image is available in two supported database engines: Microsoft SQL Server & Postgres

To ensure parity and cross-compatibility, we use a slightly older version of each.

• Microsoft SQL 2022 & 2017
• Postgres 16 & 13

If you'd like to leverage a specific version, you can clone this repository and modify the build.sh scripts in the appropriate folder.

⁠Microsoft SQL Server

There are three versions tagged for Microsoft SQL Server:

⁠Postgres

At this time, only the tables and data are fully implemented but should be accurately converted to postgres data types (including geography). Some views (specifically, the ones using XML and CROSS APPLY) have been omitted.

No functions, custom types, or stored procedures are included.

⁠Building

Run the build.sh script to download the AdventureWorks backup file from Microsoft⁠, and to build and tag the docker image.

⁠Running

⁠Microsoft SQL Server

This docker image uses the same environmental variables defined on the Microsoft SQL Server docker image⁠.

docker run -p 1433:1433 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=my_password' -d chriseaton/adventureworks:latest

⁠Postgres

This docker image uses the same environmental variables defined on the Postgres docker image⁠.

docker run -p 5432:5432 -e 'POSTGRES_PASSWORD=my_password' -d chriseaton/adventureworks:postgres

⁠Publishing

If you are a maintainer, you can publish the image to docker hub chriseaton/adventureworks⁠.

docker push chriseaton/adventureworks