---
id: sm3-reviewing-oracle-to-postgres-migration
name: "reviewing-oracle-to-postgres-migration"
url: https://skills.yangsir.net/skill/sm3-reviewing-oracle-to-postgres-migration
author: github
domain: ai-data-management-analysis
tags: ["database-migration-review", "oracle-to-postgresql", "migration-assessment", "backend-audit"]
install_count: 1800
rating: 4.30 (87 reviews)
github: https://github.com/github/awesome-copilot
---

# reviewing-oracle-to-postgres-migration

> 审查Oracle到PostgreSQL数据库迁移过程，发现潜在问题和风险，确保迁移顺利进行。

**Stats**: 1,800 installs · 4.3/5 (87 reviews)

## Before / After 对比

### Oracle到PostgreSQL迁移评审

## Readme

# reviewing-oracle-to-postgres-migration

# Oracle-to-PostgreSQL Database Migration

Surfaces migration risks and validates migration work against known Oracle/PostgreSQL behavioral differences documented in the `references/` folder.

## When to use

- **Planning** — Before starting migration work on a procedure, trigger, query, or refcursor client. Identify which reference insights apply so risks are addressed up front.

- **Validating** — After migration work is done, confirm every applicable insight was addressed and integration tests cover the new PostgreSQL semantics.

## Workflow

Determine the task type:

**Planning a migration?** Follow the risk assessment workflow.
**Validating completed work?** Follow the validation workflow.

### Risk assessment workflow (planning)

```
Risk Assessment:
- [ ] Step 1: Identify the migration scope
- [ ] Step 2: Screen each insight for applicability
- [ ] Step 3: Document risks and recommended actions

```

**Step 1: Identify the migration scope**

List the affected database objects (procedures, triggers, queries, views) and the application code that calls them.

**Step 2: Screen each insight for applicability**

Review the reference index in [references/REFERENCE.md](https://github.com/github/awesome-copilot/blob/HEAD/skills/reviewing-oracle-to-postgres-migration/references/REFERENCE.md). For each entry, determine whether the migration scope contains patterns affected by that insight. Read the full reference file only when the insight is potentially relevant.

**Step 3: Document risks and recommended actions**

For each applicable insight, note the specific risk and the recommended fix pattern from the reference file. Flag any insight that requires a design decision (e.g., whether to preserve Oracle empty-string-as-NULL semantics or adopt PostgreSQL behavior).

### Validation workflow (post-migration)

```
Validation:
- [ ] Step 1: Map the migration artifact
- [ ] Step 2: Cross-check applicable insights
- [ ] Step 3: Verify integration test coverage
- [ ] Step 4: Gate the result

```

**Step 1: Map the migration artifact**

Identify the migrated object and summarize the change set.

**Step 2: Cross-check applicable insights**

For each reference in [references/REFERENCE.md](https://github.com/github/awesome-copilot/blob/HEAD/skills/reviewing-oracle-to-postgres-migration/references/REFERENCE.md), confirm the behavior or test requirement is acknowledged and addressed in the migration work.

**Step 3: Verify integration test coverage**

Confirm tests exercise both the happy path and the failure scenarios highlighted in applicable insights (exceptions, sorting, refcursor consumption, concurrent transactions, timestamps, etc.).

**Step 4: Gate the result**

Return a checklist asserting each applicable insight was addressed, migration scripts run, and integration tests pass.
Weekly Installs233Repository[github/awesome-copilot](https://github.com/github/awesome-copilot)GitHub Stars25.7KFirst Seen7 days agoSecurity Audits[Gen Agent Trust HubPass](/github/awesome-copilot/reviewing-oracle-to-postgres-migration/security/agent-trust-hub)[SocketPass](/github/awesome-copilot/reviewing-oracle-to-postgres-migration/security/socket)[SnykPass](/github/awesome-copilot/reviewing-oracle-to-postgres-migration/security/snyk)Installed ongemini-cli201codex200opencode193cursor192kimi-cli190github-copilot190

---
*Source: https://skills.yangsir.net/skill/sm3-reviewing-oracle-to-postgres-migration*
*Markdown mirror: https://skills.yangsir.net/api/skill/sm3-reviewing-oracle-to-postgres-migration/markdown*