skills.rest
github
githubOFFICIAL
Explore all skills by this author →
WebsiteGitHub

ssma-console

Generates XML configs and runs SSMA console to migrate Oracle databases to SQL Server.

38.5k|4.9k|Updated Jun 11, 2025
Search Tags:#Oracle#SQL Server#XML#assessment report#schema conversion#Database migration#ssma
One-click install
npx skills add https://github.com/github/awesome-copilot --skill ssma-console
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ssma-console
Source: https://github.com/github/awesome-copilot/tree/main/skills/ssma-console
Command: npx skills add https://github.com/github/awesome-copilot --skill ssma-console

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Migrating an Oracle database to SQL Server with the SSMA console requires hand-writing complex XML configuration files, and small mistakes (like using standard-mode instead of tns-name-mode) cause cryptic connection and schema errors. This Skill generates correct SSMA XML configs and drives the console executable through the full migration workflow.

Core Features & Use Cases

  • XML Config Generation: Produces ssma-variables.xml, ssma-servers.xml, and per-operation script files with all placeholders resolved.
  • Four Migration Operations: Supports create-project, generate-report (assessment), migrate-schema, and migrate-data, runnable individually or as a full end-to-end migration.
  • Built-in Pitfall Fixes: Encodes known fixes for ORA-12505 SID errors, missing object-to-collect failures, and metabase force-load issues.
  • Use Case: A DBA needs to move an Oracle schema to SQL Server 2022. Provide the Oracle host, service name, credentials, and target SQL Server details, and the Skill generates the configs, runs SSMAforOracleConsole.exe, and summarizes the assessment and migration reports.

Quick Start

Migrate my Oracle schema HR on host oracle-db01 to SQL Server database HRDB on sql01 using the SSMA console and show me the assessment report.

Frequently Asked Questions about ssma-console

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

FAQPage Schema
How do I migrate an Oracle database to SQL Server with SSMA console?▼

Generate three XML files (variables, servers, and an operation script), then run SSMAforOracleConsole.exe with -s, -c, and -v flags. Run operations in order: create-project, generate-report, migrate-schema, then migrate-data for a full migration.

How to fix ORA-12505 SID not registered in SSMA for Oracle?▼

ORA-12505 occurs when SSMA uses standard-mode, which treats the instance as a SID. Switch the Oracle connection to tns-name-mode with a full service-name connect descriptor so the instance is resolved as a service name.

Why does SSMA map-schema fail with Source namespace was not found?▼

This error happens when connect-source-database lacks an object-to-collect element specifying the Oracle schema. Add <object-to-collect object-name="$OracleSchemaName$" /> inside connect-source-database instead of relying on force-load.

Which SQL Server versions does SSMA console migration support?▼

The project-type parameter supports sql-server-2016, 2017, 2019, 2022, 2025, and sql-azure targets. Set the version in the project type variable before generating the configuration files.

Does SSMA data migration require SQL Server Agent to be running?▼

No. The SQL Server Agent not running message is only a warning. SSMA uses client-side BCP for data migration, so the migration completes successfully even when the Agent service is stopped.

Related Skills

Explore More Software Engineering Skills→
s710082105s710082105
1

fr-db

Detect database schemas and generate FineReport-ready SQL queries and XML fragments.

Community
Advanced
pingcap-incpingcap-inc
2

oracle-to-tidb-migration

Assess Oracle compatibility and migrate schemas, PL/SQL, and data to TiDB Cloud.

Official
Advanced
SMOrchestra-aiSMOrchestra-ai

tech-debt

Identify, categorize, and prioritize technical debt across codebases.

Official
Intermediate
claude-office-skillsclaude-office-skills
368

Database Sync

Automate database synchronization, replication, and migration between heterogeneous systems.

Official
Advanced