skills.rest
RyoMurakami1983
RyoMurakami1983COMMUNITY
Explore all skills by this author →
WebsiteGitHub

dotnet-access-to-oracle-migration

Migrate Access SQL queries and structures to Oracle with C# code generation.

2|Updated Feb 12, 2026
Search Tags:#csharp#database migration#oracle#dotnet#access#sql conversion
One-click install
npx skills add https://github.com/RyoMurakami1983/skills_repository --skill dotnet-access-to-oracle-migration
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dotnet-access-to-oracle-migration
Source: https://github.com/RyoMurakami1983/skills_repository/tree/main/dotnet/dotnet-access-to-oracle-migration
Command: npx skills add https://github.com/RyoMurakami1983/skills_repository --skill dotnet-access-to-oracle-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill automates the complex and error-prone process of migrating database queries and structures from Microsoft Access to Oracle, while also generating corresponding .NET C# code for seamless application integration.

Core Features & Use Cases

  • Full Migration Workflow: Guides users through TNS name resolution, connection testing, Access naming conventions, object type detection (VIEW/SYNONYM), column validation, SQL syntax conversion, record count verification, and C# code generation.
  • Error Handling: Leverages Oracle ORA-* error codes to diagnose and fix connection, authentication, and network issues.
  • Use Case: A developer needs to migrate a legacy Access database used by a .NET application to a more robust Oracle backend. This Skill will convert the Access SQL queries, ensure compatibility with Oracle, and provide the necessary C# classes to interact with the new Oracle database.

Quick Start

Use the dotnet-access-to-oracle-migration skill to convert the provided Access SQL query to Oracle and generate the C# IOracle implementation.

Frequently Asked Questions about dotnet-access-to-oracle-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert Access SQL queries to Oracle syntax for a .NET application?▼

To convert Access SQL queries to Oracle syntax, this migration process reverses Access naming conventions, detects VIEW and SYNONYM objects, validates columns, and generates C# IOracle interface implementations with proper string escaping.

How do I test Oracle database connectivity and resolve TNS names during a migration?▼

To test Oracle database connectivity and resolve TNS names during migration, the workflow utilizes tnsping for TNS resolution and performs connection testing with ORA-* error diagnostics to identify authentication or network issues.

Can I generate C# code automatically when migrating from Access to Oracle?▼

Yes, you can generate C# code automatically during the Access to Oracle migration. The workflow produces .NET C# code featuring IOracle interface implementations and proper string escaping for seamless application integration.

How do I validate record counts between Access and Oracle databases after SQL conversion?▼

To validate record counts between Access and Oracle databases after SQL conversion, the workflow performs record count verification using a 'near equal' tolerance to account for acceptable data variations.

What do ORA-* error codes mean when testing an Oracle connection in C#?▼

ORA-* error codes are Oracle diagnostic messages used during connection testing to pinpoint specific connection, authentication, or network failures when attempting to integrate C# applications with Oracle databases.

Related Skills

Explore More Software Engineering Skills→
wfukatsuwfukatsu
12

analyze-oracle-schema

Analyze Oracle database schemas and generate a Markdown report.

Community
Advanced
christian289christian289

enforcing-dto-record

Enforce C# Data Transfer Objects to be declared as records.

Community
Basic
RyoMurakami1983RyoMurakami1983
2

dotnet-oracle-wpf-integration

Integrate Oracle Database connectivity into .NET WPF applications with repository pattern and ORA-* error handling.

Community
Advanced
partme-aipartme-ai
610

oracle

Provide guidance for Oracle SQL, PL/SQL, and database administration.

Official
Intermediate