Agent skill · software engineering · github
ssma-console
Use when: SSMA console operations — create project, generate assessment report, convert schema, migrate data, Oracle to SQL Server migration, schema conversion, data migration
Why this skill is useful
Adds executable scripts for Oracle to SQL Server migration that automate the entire process and generate necessary XML configurations.
What it needs
Requires ssma installed locally. About 3k tokens when loaded. Last updated 2026-08-07. 37,534 stars on the source repository.
What this skill does
SSMA Console — Oracle to SQL Server Migration Generate XML configs and invoke SSMAforOracleConsole.exe directly — no external scripts or wrappers. Operations (run in order for "full migration"): 1. create-project — connect source & target, map schema 2. generate-report — assessment report 3. migrate-schema — convert & deploy schema 4. migrate-data — convert, deploy, migrate data end-to-end Collect Inputs Ask for missing parameters. Defaults in parentheses. Oracle: Host (localhost), Port (1521), Instance (required, service name), User, Password, Schema SQL Server: Server, Database, User, Password, Encrypt (true), Trust Server Certificate (true), Target Schema (dbo) Project: Name (ssma-migration), Folder (.), Type (sql-server-2022 — also 2016/2017/2019/2025/sql-azure), SSMA Path (C:\Program Files\Microsoft SQL Server Migration Assistant for Oracle\bin\SSMAforOracleConsole.exe) Generate XML Files Resolve ALL {PLACEHOLDER} tokens before writing. Generate 3 files: ssma-variables.xml ssma-servers.xml CRITICAL: Use tns-name-mode — standard-mode treats instance as SID and fails with ORA-12505. Operation Script XML Generate one script per operation. All scripts share this common <config> block (add <object-overwrite action="overwrite" /> for migrate-schema/migrate-data, add <data-migration-connection source-use-last-used="true" target-server="targetsqlserver" /> for migrate-data, use every-5% progress for schema/data ops): All scripts start with this preamble in <script-commands>: CRITICAL: Always include <object-to-collect> — without it, map-schema fails with "Source namespace was not found". …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills github/ssma-console