Deployment Guide

0aRefresh the baseline

This takes the current baseline .mdf, applies all pending migration scripts from database/migrations/, assigns a new version number, and generates a deployment script. The migration files are deleted from the server after being consolidated into the new baseline.

1. Open the dashboard at https://mc.shareddev.com
2. Go to the MigrationCoordinator project detail page
3. Click Refresh Baseline
4. Download the generated files to your local repo:
   • Updated baseline .mdf → database/baseline/MigrationCoordinator.mdf
   • Version deployment script .sql → database/versions/
5. Commit and push both files to main

0bApply the version SQL to production

Use the newly generated version SQL to update the production database:

1. Connect to 136.144.128.65 in SSMS as migcoord
2. Select the MigrationCoordinator_prod database
3. Run the new version SQL file (each migration is wrapped with skip-if-applied guards, so it is safe to re-run)

1Build for Linux

Compile the project for Linux x64 without bundling the .NET runtime (already installed on the server).

Copycd C:\Repositories\MigrationSystem
dotnet publish src/MigrationCoordinator/MigrationCoordinator.csproj -c Release -r linux-x64 --self-contained false -o publish_temp

2Prepare server upload folder

Remove any old deploy folder and create a fresh one.

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo rm -rf /tmp/migcoord_deploy && mkdir -p /tmp/migcoord_deploy"

3Upload files to the server

Copy all built files including subdirectories (wwwroot, localization folders).

Copyscp -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" -r C:/Repositories/MigrationSystem/publish_temp/* tmpwork@136.144.128.65:/tmp/migcoord_deploy/

4Stop the service

Stop the running MigrationCoordinator so files can be safely replaced.

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo systemctl stop migrationcoordinator"

5Backup production appsettings.json

The build output includes a default appsettings.json that will overwrite the production config. Save it first.

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo cp /var/www/migrationcoordinator/appsettings.json /tmp/appsettings_backup.json"

6Copy new files to install directory

Replace the application files with the new build. Use -r for subdirectories.

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo cp -r /tmp/migcoord_deploy/* /var/www/migrationcoordinator/"

7Restore production appsettings.json

Put the production config back (connection string, API key, etc.).

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo cp /tmp/appsettings_backup.json /var/www/migrationcoordinator/appsettings.json"

8Fix file ownership

Files were copied as root (via sudo). The service runs as the migrationcoordinator user and needs to own its files.

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo chown -R migrationcoordinator:migrationcoordinator /var/www/migrationcoordinator"

9Start the service

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo systemctl start migrationcoordinator"

10Verify

Check the service is running:

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo systemctl status migrationcoordinator"

Should show active (running). Also check https://mc.shareddev.com in the browser.

11Remove temporary files

Local:

Copyrm -rf C:\Repositories\MigrationSystem\publish_temp

Server:

Copyssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo rm -rf /tmp/migcoord_deploy /tmp/appsettings_backup.json"

Copy# Stop the broken service
ssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo systemctl stop migrationcoordinator"

# Restore from backup (if you made one before deploying)
ssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo cp -r /var/www/migrationcoordinator_backup/* /var/www/migrationcoordinator/"
ssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo chown -R migrationcoordinator:migrationcoordinator /var/www/migrationcoordinator"

# Start the old version
ssh -i "C:\Repositories\SharedDev\ISO27001\Apps\tmp\tmpwork_key" tmpwork@136.144.128.65 "sudo systemctl start migrationcoordinator"