Skip to content

A docker image using Microsoft's AdventureWorks (demo/sample) database pre-loaded and installed on SQL Server or Postgres.

Notifications You must be signed in to change notification settings

chriseaton/docker-adventureworks

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Docker AdventureWorks

This project is available on...

To run one of the samples, see §Running below.
You can find samples of a docker or docker-compose.yaml files in the samples/ directory.

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:

Tag Description
latest or oltp or oltp-2022 This image contains the standard OLTP version of the AdventureWorks database on Microsoft SQL 2022.
oltp-2017 This image contains the standard OLTP version of the AdventureWorks database on Microsoft SQL 2017.
datawarehouse or datawarehouse-2022 This image utilizes the data warehouse version of the AdventureWorks database on Microsoft SQL 2022.
datawarehouse-2017 This image utilizes the data warehouse version of the AdventureWorks database on Microsoft SQL 2017.
light or light-2022 This image utilizes the "light" version of the AdventureWorks database on Microsoft SQL 2022.
light-2017 This image utilizes the "light" version of the AdventureWorks database on Microsoft SQL 2017.

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.

Tag Description
postgres or postgres-16 This image adapts the "light" version of the AdventureWorks database to Postgres 16.
postgres-13 This image adapts the "light" version of the AdventureWorks database to Postgres 13.

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_password1' -d chriseaton/adventureworks:latest

Tip

Replace My_password1 with your own secure password. Note that the password must pass minimum complexity requirements or you won't be able to connect!

Postgres

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

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

Development

Building

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

Publishing

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

docker push chriseaton/adventureworks

About

A docker image using Microsoft's AdventureWorks (demo/sample) database pre-loaded and installed on SQL Server or Postgres.

Topics

Resources

Stars

Watchers

Forks