Restore instructions for AdventureWorks Database on Kubernetes

Restore MSSQL Adventureworks.md

Copy Adventureworks to master

scp Adventureworks.bak to the master

Copy Into Container

POD=mssql-1121156913-8sms4
kubectl cp /root/AdventureWorks2016CTP3.bak $POD:/root/AdventureWorks2016CTP3.bak

Run the Restore

kubectl exec  -it $POD --  /opt/mssql-tools/bin/sqlcmd -S localhost \
               -U SA -P 'P@ssw0rd' -Q "RESTORE DATABASE [AdventureWorks2016CTP3]      \
               FROM  DISK = '/root/AdventureWorks2016CTP3.bak' WITH Move              \
               'AdventureWorks2016CTP3_Data' to                                       \
               '/var/opt/mssql/data/AdventureWorks2016CTP3_Data.mdf', move            \
               'AdventureWorks2016CTP3_Log' to                                        \
               '/var/opt/mssql/data/AdventureWorks2016CTP3_Log.ldf', move             \
               'AdventureWorks2016CTP3_mod' to                                        \
               '/var/opt/mssql/data/AdventureWorks2016CTP3_Mod.mdf'"

Verify

kubectl exec  -it $POD --  /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'P@ssw0rd' -d AdventureWorks2016CTP3 \
                 -Q "Select count(*) from Person.Person"
kubectl exec  -it $POD --  /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'P@ssw0rd' -d AdventureWorks2016CTP3 \
                 -Q "Select count(*) from Sales.SalesOrderDetail"