Sweep: Create Docker Compose file to create SQL Server 2022 database to use when running Migrator

[mrbiggred]

The Docker Compose file should be similar to this Docker command:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=password1234!" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

[sweep-ai[bot]]

🚀 Here's the PR! #6

💎 Sweep Pro: You have unlimited Sweep issues

Actions

• [ ] ↻ Restart Sweep

  Step 1: 🔎 Searching

  Here are the code search results. I'm now analyzing these search results to write the PR.

Relevant files (click to expand). Mentioned files will always appear here.

https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/MigratorConsole/App.config#L1-L13 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/MigratorGUI/App.config#L1-L82 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/MigratorTests/App.config#L1-L76 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/README.md#L1-L34 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/MigratorTests/TestBase.cs#L1-L98 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/Migrator/packages.config#L1-L37 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/Migrator/Migrator.csproj#L1-L270 https://github.com/saturdaymp/Migrator/blob/e34049d7e53bd1f98789c5a8b4e9cd5e0a8948e2/Source/Migrator.sln#L1-L57

Step 2: ⌨️ Coding

docker-compose.yml

Create a new Docker Compose file to define the SQL Server 2022 service.

version: '3.8'

services:
  db:
    image: mcr.microsoft.com/mssql/server:2022-latest
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=password1234! 
    ports:
      - 1433:1433

Source/MigratorConsole/App.config

Update the connection string to point to the SQL Server running in the Docker container.

--- 
+++ 
@@ -1,3 +1,3 @@
   <connectionStrings>
-    <add name="Default" connectionString="Server=(local);Database=MigratorTest;Trusted_Connection=True;"/>
-  </connectionStrings>
+    <add name="Default" connectionString="Server=localhost,1433;Database=MigratorTest;User Id=sa;Password=password1234!;TrustServerCertificate=True;"/>
+  </connectionStrings>  

Source/MigratorGUI/App.config

Update the connection string to point to the SQL Server running in the Docker container.

--- 
+++ 
@@ -1,3 +1,3 @@
   <connectionStrings>
-    <add name="Default" connectionString="Server=localhost;Database=MigratorTest;Uid=sa;Pwd=Password1234!;TrustServerCertificate=True;" />
+    <add name="Default" connectionString="Server=localhost,1433;Database=MigratorTest;User Id=sa;Password=password1234!;TrustServerCertificate=True;" />
   </connectionStrings>

Source/MigratorTests/App.config

Update the connection string to point to the SQL Server running in the Docker container.

--- 
+++ 
@@ -1,3 +1,3 @@
   <connectionStrings>
-    <add name="Master" connectionString="Server=localhost;Database=Master;Uid=sa;Pwd=password1234!;TrustServerCertificate=True;" />
+    <add name="Master" connectionString="Server=localhost,1433;Database=Master;User Id=sa;Password=password1234!;TrustServerCertificate=True;" />
   </connectionStrings>

Step 3: 🔄️ Validating

Your changes have been successfully made to the branch sweep/create_docker_compose_file_to_create_sql. I have validated these changes using a syntax checker and a linter.

---

[!TIP] To recreate the pull request, edit the issue title or description.

This is an automated message generated by Sweep AI.