My course experiment needs School_Data.MDF and School_Log.LDF. Installing SQL Server Data Tools - Business Intelligence for Visual Studio 2013 also installs. Otherwise, the mssql user in the SQL Server container cannot read these two files due to the file owner setting during docker cp copying. Download & Install Visual Studio from Microsoft for free.
Before copying, you need to change the permissions to be readable and writable by others. According to this document from Mircosoft, it can be imported in the form of a file through SQL statements.įirst, copy the local files to the container through docker cp. Launch Azure Data Studio, connect to the localhost.Īfter successfully connected, you can click on the New Query above to query.īecause of the database experiment this semester, I also gave the two database files MDF and LDF, which need to be imported into this SQL Server container. MSSQL_SA_PASSWORD needs to be strong password, otherwise the container will exit with code 1īut since there is no SQL Server Management Studio on the Mac, I use Azure Data Studio for alternative, although it has not supported M1 natively. Use SQL Server on M1 Mac Use SQL Server on M1 Mac Table of contentsĭocker pull /azure-sql-edgeĭocker run -cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' -p 1433:1433 -name SQLServer -d /azure-sql-edge.Analysis of the front-end AES-CBC encryption.
