Install SQL Server Via Docker
First download and install Docker
Enter the following in the command line to download the container, but make sure to change the password to a secure one you wish to use:
docker pull mcr.microsoft.com/mssql/server:2022-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Password123" \
-p 1433:1433 --name sql2022 --hostname sql2022 \
-d \
mcr.microsoft.com/mssql/server:2022-latestTo check the container is running and to stop and start it etc. use the Docker desktop application.
Open Datagrip and select a new project
Select the database folder within our project as the path
Once the project is open, select file from the top menu bar and select renam project, then name the project CrudApp
From the database explorer left-hand menu, choose add a data source and select Microsoft SQL Server
Host should be set to localhost
Enter port number 1433
Set Authentication to User & Password
Set user to sa
Set the password to Password123
You can now select a test connection to ensure that it works, then press done