Creating Oracle To Postgres Migration Integration Tests

This walks you through creating xUnit integration tests for .NET data access code during an Oracle to Postgres migration. It generates tests that run against both databases to prove behavioral consistency, using deterministic seed data and database-agnostic assertions. The workflow is prescriptive: discover your test project conventions, identify repositories and DAOs to test, create seed files, write test cases that inherit from your base class for automatic transaction rollback, then review every assertion for determinism. Oracle is treated as the source of truth. The main value is keeping test logic portable so the same tests validate both pre-migration Oracle behavior and post-migration Postgres behavior without rewriting assertions around platform-specific error messages or syntax quirks.

Install to Claude Code

npx -y skills add github/awesome-copilot --skill creating-oracle-to-postgres-migration-integration-tests --agent claude-code