docker pull mcr.microsoft.com/mssql/server:2022-latest

docker run -e "ACCEPT_EULA=Y" -e 'MSSQL_SA_PASSWORD=LikeAndSubscribe!1' -p 51433:1433 -d --name sqlcontainer --hostname sqlcontainer -d mcr.microsoft.com/mssql/server:2022-latest

copy the bak file inside docker

docker cp /home/abhisheklakra/Downloads/datawarehouse/AdventureWorks2014.bak e26c646fcc3d:/var/opt/mssql/backup/

then run this commands

RESTORE FILELISTONLY
FROM DISK = '/var/opt/mssql/backup/AdventureWorks2014.bak';

USE master;
RESTORE DATABASE AdventureWorks2014
FROM DISK = '/var/opt/mssql/backup/AdventureWorks2014.bak'
WITH MOVE 'AdventureWorks2014_Data' TO '/var/opt/mssql/data/AdventureWorks2014.mdf',
     MOVE 'AdventureWorks2014_Log' TO '/var/opt/mssql/data/AdventureWorks2014_log.ldf',
     REPLACE;

---

• we have HumanResource table
• person table,
• production table
• sales table
• purchasing

goal is to create data mart for sales and human resource then as we go we can create more data mart

sales Data Mart

• for this we are considering SalesOrderDetail and SalesOrderHeader tables

SalesOrderHeader (our transaction table)

• selling adventure sports bike