DevelopmentMédio

Planning Integration Testing for Oracle-to-PostgreSQL Migration

porgithub·github· v1.0.0 · atualizado em 2026-04-10

Score

Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Analyzes a single project to identify repositories, DAOs, and service layers that interact with the database, then produces a structured testing plan. Use when planning integration test coverage for a migrated project, identifying which data access methods need tests, or preparing for Oracle-to-PostgreSQL migration validation.

integration-testingdatabase-migrationoracle-to-postgresdata-accessdotnettesting-planmigration-validation

0Stars

0Forks

0Usos

Fork

Documento do Skill

SKILL.mdplanning-oracle-to-postgres-migration-integration-testing/workflow

```

Progress:

[ ] Step 1: Identify data access artifacts

[ ] Step 2: Classify testing priorities

[ ] Step 3: Write the testing plan

```

**Step 1: Identify data access artifacts**

Scope to the target project only. Find classes and methods that interact directly with the database — repositories, DAOs, stored procedure callers, service layers performing CRUD operations.

**Step 2: Classify testing priorities**

Rank artifacts by migration risk. Prioritize methods that use Oracle-specific features (refcursors, `TO_CHAR`, implicit type coercion, `NO_DATA_FOUND`) over simple CRUD.

**Step 3: Write the testing plan**

Write a markdown plan covering:

List of testable artifacts with method signatures

Recommended test cases per artifact

Seed data requirements

Known Oracle→PostgreSQL behavioral differences to validate

Telemetria de Agentes

Execuções

total

Taxa de Sucesso

últimos 30d

Latência Média

0.0s

p50

Alucinação

0.0%

detecção

Tokens Entrada

avg 0/exec

Tokens Saída

avg 0/exec

Uso por Plataforma

Skills Relacionados

Compõe comOracle-to-PostgreSQL Database Migration

80%

Compõe comScaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration

80%

Compõe com ←Creating an Oracle-to-PostgreSQL Master Migration Plan

80%

Compõe com ←Creating Bug Reports for Oracle-to-PostgreSQL Migration

80%

Compõe com ←Creating Integration Tests for Oracle-to-PostgreSQL Migration

80%

Compõe com ←Migrating Stored Procedures from Oracle to PostgreSQL

80%

Similar aAPI Test Generator

60%

Similar aTest Data Generator

60%

Co-executedTest Data Generator

51%

Co-executedScaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration

48%

Co-executed ←Creating Integration Tests for Oracle-to-PostgreSQL Migration

47%

Árvore do Skill

Planning Integration Testing for Oracle-to-PostgreSQL Migration

planning-oracle-to-postgres-migration-integration-testing

Fases Cognitivas4

1.SENSE

2.CONTEXTUALIZE

3.HYPOTHESIZE

4.ACT

Triggers6

create an integration testing plan for Oracle to PostgreSQL migrationplan integration test coverage for a migrated projectidentify data access methods needing tests after migrationprepare for Oracle to PostgreSQL migration validationanalyze project for database interaction artifacts for testinggenerate a testing plan for a .NET project migrated from Oracle to PostgreSQL

Avaliar este Skill

Score Breakdown

⭐Avaliação Humana0%

🤖Sucesso de Agentes0%

🕐Atualidade100%

🔗Saúde de Dependências100%

🕸️Centralidade no Grafo0%

🛡️Segurança49%

CompositeScore = α·Humano + β·Agente + γ·Recência + δ·Deps + ε·Centralidade + ζ·Segurança

Instalação

$ synaptic mcp download planning-oracle-to-postgres-migration-integration-testing

$ synaptic skills detail planning-oracle-to-postgres-migration-integration-testing

$ synaptic skills live planning-oracle-to-postgres-migration-integration-testing

Links

GitHub Repository