restore-mssql-adventure-works.sh

# #!/bin/bash
docker exec -it oltp_initial_msqql_db /opt/mssql-tools/bin/sqlcmd \
   -S localhost -U SA -P 'Apadanadev@1' -Q 'RESTORE DATABASE AdventureWorks2022 FROM DISK = "/mnt/AdventureWorks2022.bak" WITH MOVE "AdventureWorks2022" TO "/var/opt/mssql/data/AdventureWorks2022.mdf", MOVE "AdventureWorks2022_log"  TO "/var/opt/mssql/data/AdventureWorks2022_log.ldf"'


docker exec -it olap_initial_msqql_db /opt/mssql-tools/bin/sqlcmd \
   -S localhost -U SA -P 'Apadanadev@1' -Q 'RESTORE DATABASE AdventureWorksDW2022 FROM DISK = "/mnt/AdventureWorksDW2022.bak" WITH MOVE "AdventureWorksDW2022" TO "/var/opt/mssql/data/AdventureWorksDW2022.mdf", MOVE "AdventureWorksDW2022_log"  TO "/var/opt/mssql/data/AdventureWorksDW2022.ldf"'