Scaffolding Oracle To Postgres Migration Test Project

This scaffolds the test infrastructure you need before writing integration tests for an Oracle to Postgres migration in .NET. It creates an xUnit project with transaction rollback on every test so you're never polluting your database, plus a seed data manager that loads test data inside those transactions. The workflow inspects your target project to match .NET versions exactly, sets up Oracle connectivity first (since Oracle is the source of truth for expected behavior), and verifies everything compiles before you start writing actual tests. It's focused on setting up the plumbing once so your test cases stay clean. If you're migrating databases and need repeatable tests that don't leave artifacts behind, this handles the boring setup work.

skills.sh installs: 1.7K
GitHub stars: 41K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-project --agent claude-code

Installs into .claude/skills of the current project.

Files

Scaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration

Creates a compilable, empty xUnit test project with transaction management and seed data infrastructure for a single target project. Run once per project before writing tests.

Workflow

Progress:
- [ ] Step 1: Inspect the target project
- [ ] Step 2: Create the xUnit test project
- [ ] Step 3: Implement transaction-rollback base class
- [ ] Step 4: Implement seed data manager
- [ ] Step 5: Verify the project compiles

Step 1: Inspect the target project

Read the target project's .csproj to determine the .NET version and existing package references. Match these versions exactly — do not upgrade.

Step 2: Create the xUnit test project

Target the same .NET version as the application under test.
Add NuGet packages for Oracle database connectivity (Oracle.ManagedDataAccess.Core) and xUnit.
Add a project reference to the target project only — no other application projects.
Add an appsettings.json configured for Oracle database connectivity.

Step 3: Implement transaction-rollback base class

SKILL.md on GitHub