Skip to content

Instantly share code, notes, and snippets.

@raphaeldealmeida

raphaeldealmeida/docker_sqlsrv.sh

Last active April 3, 2019 23:31
Show Gist options
  • Save raphaeldealmeida/2b2778dcb5a15a395695814a4d239a74 to your computer and use it in GitHub Desktop.
Save raphaeldealmeida/2b2778dcb5a15a395695814a4d239a74 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
docker_sqlsrv.sh
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 --name sql1 -d -v /home/raphael/projects/freelas/OnBoard/Backup:/home/backup mcr.microsoft.com/mssql/server:2017-latest
sudo docker start sql1
sudo docker exec -it sql1 "bash"
## on container, it request pass
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE central FROM DISK = '/home/backup/Central.bak' WITH MOVE 'central' TO '/var/opt/mssql/data/central.mdf', MOVE 'central_log' TO '/var/opt/mssql/data/central.ldf'"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE onboard FROM DISK = '/home/backup/Onboard.bak' WITH MOVE 'onboard' TO '/var/opt/mssql/data/onboard.mdf', MOVE 'onboard_log' TO '/var/opt/mssql/data/onboard.ldf'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment