Skip to content

Files

Latest commit

max-ieremenkomax-ieremenko
update to latest mssql/server image
Nov 4, 2024
40f92bc · Nov 4, 2024

History

History

SqlServerDockerImage

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
create-database-scripts
create-database-scripts
Mar 14, 2021
upgrade-database-scripts
upgrade-database-scripts
Mar 14, 2021
README.md
README.md
Mar 14, 2021
create-database-build-image.ps1
create-database-build-image.ps1
Mar 14, 2021
create-database.dockerfile
create-database.dockerfile
Nov 4, 2024
upgrade-database-build-image.ps1
upgrade-database-build-image.ps1
Mar 14, 2021
upgrade-database-scripts.dockerfile
upgrade-database-scripts.dockerfile
Nov 4, 2024

README.md

Two steps example how to create and upgrade database in ms sql server linux container

To run scripts switch your docker to linux containers.

Step 1: create an image with sql server and SqlDatabaseDemo database version 1.0.

Database scripts are located in create-database-scripts folder.

Build image sqldatabase/mssql-server-linux-demo:create:

PS> .\create-database-build-image.ps1

Test image:

PS> docker run -it --rm -p 1433:1433 sqldatabase/mssql-server-linux-demo:create

Step 2: create an image with sql server and SqlDatabaseDemo database version 2.0.

During the build process we update SqlDatabaseDemo database from step 1 to version 2.0. Database scripts are located in upgrade-database-scripts folder.

Build image sqldatabase/mssql-server-linux-demo:upgrade:

PS> .\upgrade-database-build-image.ps1

Test image:

PS> docker run -it --rm -p 1433:1433 sqldatabase/mssql-server-linux-demo:upgrade