MSSQL RESTORE DATABASE TSQL UBUNTU

docker-sql-server.md

docker run --restart=always --name=sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=thePassword_' -p 1433:1433 -d microsoft/mssql-server-linux:latest

dockercp.md

docker cp mydatabase.bak sqlserver:/tmp/mydatabase.bak

export.md

USE [database-name];
GO
BACKUP DATABASE [database-name]
TO DISK = '/tmp/database-name.bak'
   WITH FORMAT,
      NAME = 'database-name';
GO

renamedb.md

USE master;  
GO  
ALTER DATABASE MyTestDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;
GO  
ALTER DATABASE MyTestDatabaseCopy SET MULTI_USER
GO

restore.md

RESTORE DATABASE [databaseName] FROM DISK='/tmp/databaseName.bak'
WITH MOVE 'databaseName' TO '/var/opt/mssql/data/databaseName.mdf', 
MOVE 'databaseName_Log' TO '/var/opt/mssql/data/databaseName.ldf';