Nothing technical is holding this repo on the three-week release. It either already deploys without downtime (AWS) or is a modern, well-tested service the automated stealth path can carry today. Modern runtime, good tests, no hosted legacy transport: the automated stealth path can carry it today. Calls legacy WCF endpoints as a client; stay dual-version safe on client package upgrades.

• 2 system(s) depend on this repo; during a rolling deploy they will talk to old and new versions at once, so responses must stay compatible
• Consumes WCF contract packages: never take a breaking client bump mid-feature, and treat obsolete warnings as migration debt
• Serialized state or messages in flight (Redis or queues): new code must deserialize objects written by the previous version
• Feature flags come from phenix-feature-service (WCF-only): flag reads themselves are a legacy dependency to watch

1. Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
2. Make every change dual-version safe: backwards-compatible APIs (new major version for breaking wire changes), expand and contract for any schema change, and consumers tolerant of unknown fields.
3. Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
4. Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
5. Route deployments through the Workflow Engine's automated drain, deploy, health-check, return cycle (the path proven by the first automated production run in mid-2026).
6. Verify with area-scoped regression rather than the whole-platform cycle, and watch error rates after rollout with automated rollback on alert.

The database is solely owned by this system, so the migration is self-contained. Recommended target: PostgreSQL.

1. Inventory the schema and query surface of sqlserver:TravelCounsellorWebDetail: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
2. Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
3. The repo already uses Entity Framework: swap the provider (Npgsql for PostgreSQL) behind the existing model, then burn down the provider-specific differences the test suite finds.
4. Stand up the target alongside SQL Server, backfill with an ETL pass (pgloader or an export/import job), then dual-write or replicate until parity is proven.
5. Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
6. Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.

Modern runtime, no hosted legacy transport: this service can follow the estate's proven container path (Dockerfile, shared pipeline template, ECS via Terraform).

1. Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
2. Log to stdout and expose a health check endpoint so ECS can supervise it.
3. Adopt the shared ci.yml pipeline template with the container parameters (awsRegion, containerAfterBuild, ecsTerraformRepo), which is exactly how the estate's existing AWS services deploy.
4. Define the service in the Terraform repo, deploy to a non-production environment, then shift traffic and disarm the deployment-group release pipeline.