waquwex/SQLServerOnDocker.md

Last active February 26, 2024 15:42

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/waquwex/15d29c650c3d36f476a2f5a57209fec5.js"></script>
Save waquwex/15d29c650c3d36f476a2f5a57209fec5 to your computer and use it in GitHub Desktop.

Download ZIP

SQLServer on Docker

Raw

SQLServerOnDocker.md

Deploy Image to Docker

sh docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD={PW}' -p 1401:1433 -d mcr.microsoft.com/mssql/server

Copy .bak File Docker Instance

sh docker cp Footballers.bak {INSTANCE_ID}:/var/opt/mssql/data/{BACKUP_NAME}.bak

Restore Backup To SQL Server with CLI

sh docker exec -it {INSTANCE_ID} bash sh /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P {PW} -d master -Q "RESTORE DATABASE [{DB_NAME}] FROM DISK='/var/opt/mssql/data/{BACKUP_NAME}.bak' WITH MOVE '{DBNAME}' TO '/var/opt/mssql/data/{DBNAME}.mdf', MOVE '{DBNAME}_Log' TO '/var/opt/mssql/data/{DBNAME}.ldf'"

Connection String for Clients

Server=127.0.0.1,1401;Database={DBNAME};User Id=SA;Password{PW}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment