Skip to content

Instantly share code, notes, and snippets.

@ryangraffy

ryangraffy/gist:21b8110c3591981fccca9aa129788fb7

Created September 19, 2018 13:02
Show Gist options
  • Save ryangraffy/21b8110c3591981fccca9aa129788fb7 to your computer and use it in GitHub Desktop.
Save ryangraffy/21b8110c3591981fccca9aa129788fb7 to your computer and use it in GitHub Desktop.
Download ZIP
Useful docker + sqlserver commands
Raw
gistfile1.txt
Copy a .bak to the container
docker cp blah.bak sqlserver:/tmp
From https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017
Run a sql terminal
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'thePassword_'
Create a database
CREATE DATABASE TestDB
SELECT Name from sys.Databases
go
Rename a database
USE master;
GO
ALTER DATABASE AdventureWorks2012
Modify Name = Northwind ;
GO
RESTORE FILELISTONLY FROM DISK = '/tmp/gohi5-prod-test-20180713.bak
RESTORE DATABASE [gohi5] FROM DISK='/tmp/gohi5-prod-test-20180713.bak'
WITH MOVE 'gohi5' TO '/var/opt/mssql/data/gohi5.mdf',
MOVE 'gohi5_Log' TO '/var/opt/mssql/data/gohi5.ldf';
@ryangraffy
Copy link
Author

Export: /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q sqlcmd -S localhost -U SA -Q "BACKUP DATABASE [gohi5-dev] TO DISK = N'/var/opt/mssql/data/gohi5-dev.bak' WITH NOFORMAT, NOINIT, NAME = 'gohi5-dev', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

@ryangraffy
Copy link
Author

ryangraffy commented Dec 5, 2018 •
edited
Loading

Import: /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [gohi5-dev] FROM DISK = N'/tmp/gohi5-dev.bak' WITH MOVE 'gohi5' TO '/var/opt/mssql/data/gohi5.mdf', MOVE 'gohi5_Log' TO '/var/opt/mssql/data/gohi5.ldf';"

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