thombolin/mssql_attach
SQL2017 Image attach database on RUN
30
SQL2017 Image attaches database stored in c:\temp on host, c:\sqlserver in container. Currently hard coded database name of dockertest using dockertest.mdf and dockertest_log.ldf stored in c:\temp on host
#escape=` FROM microsoft/mssql-server-windows-developer:latest
#create directory within SQL container for database files RUN powershell mkdir C:\SQLServer
#copy the database files from host to container #COPY SQLFiles\DockerTest.mdf C:\SQLServer #COPY SQLFiles\DockerTest_log.ldf C:\SQLServer
#SET ENV VARIABLES FOR EULA, DATA_PATH (USED IN OTHER SCRIPTS) AND SA_PASSWORD (SET VIA start script in MSSQL image)
ENV ACCEPT_EULA="Y" SA_PASSWORD="SQLServer2017"
attach_dbs='[{"dbName":"dockertest","dbFiles":["C:\SQLServer\DockerTest.mdf","C:\SQLServer\DockerTest_log.ldf"]}]'
#docker run -d -p1433:1433 -v c:\temp:c:\sqlserver --name sql01 thombolin/mssql_attach
docker pull thombolin/mssql_attach