Open mssql bak in linux

open-mssql-bak-in-linux

Steps
  - install Azure data studio
  - docker container
  - copy file
  - connect
  - import
  - inspect
 
# Azure Data Studio
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15
 
# Docker Image
https://hub.docker.com/_/microsoft-mssql-server
 
# Install Azure Data Studio
 
 https://go.microsoft.com/fwlink/?linkid=2151506
 
# Docker container
# copy file
docker run -d --name sql1 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=StrongPwd1234567' -p 1433:1433 microsoft/mssql-server-linux
docker start sql1
docker exec -d sql1 mkdir /var/opt/mssql/backup
docker cp dbname.bak sql1:/var/opt/mssql/backup

# connect
Connection type: Microsoft SQL Server
Server: localhost
User name: sa
Password: StrongPwd1234567
 
# import
Open the SERVERS, right-click and select Manage.
Restore on the Tasks widget
File
/var/opt/mssql/backup

# inspect

Great cheat sheet, thank you!

But there needs to be

docker run -d --name sql1 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=StrongPwd1234567' -p 1433:1433 mcr.microsoft.com/mssql/server

instead of

docker run -d --name sql1 -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=StrongPwd1234567' -p 1433:1433 microsoft/mssql-server-linux