kromm77 icon

[DOCKER] [SQL SERVER] Copy db from container to another

kromm77 | PRO | 07/17/19 01:23:01 PM UTC | 0 ⭐ | 553 👁️ | Never ⏰ | []
Bash |

580 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourStrong!Passw0rd>' -Q 'BACKUP DATABASE  [demodb] TO DISK = "/var/opt/mssql/data/demodb_LogBackup.bak" WITH STATS = 10'
 
sudo docker cp "sql1:/var/opt/mssql/data/demodb_LogBackup.bak" "C:\temp\DATABASESQLSERVER1.bak" 
 
sudo docker cp  "C:\temp\DATABASESQLSERVER1.bak" "sql2:/var/opt/mssql/data/demodb_LogBackup.bak"
 
sudo docker exec -it sql2 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>' -Q 'RESTORE DATABASE  [yourdbname] FROM DISK = "/var/opt/mssql/data/demodb_LogBackup.bak"'

Comments