Skip to content

Extraction Tools

Overview

QMigrator Extraction Tools are secure, agentless executables that connect directly to source databases to extract DDL (CREATE statements). They require no agent installation, no Docker, and no database client, making them suitable for restricted or air-gapped environments. The extraction tool exports all schema objects to .sql files for conversion and migration.

Both Windows (.exe) and Linux binaries are available for each platform.

Prerequisites

  • Source database is reachable from the machine running the tool
  • Database listener or service is active and accepting connections
  • Database user has read-only privileges on required system views
  • Supported OS: Windows or Linux (64-bit)
  • Run all commands from the folder where the executable is located

Installation & Setup

Download Tools

Download the executable for your source platform:

qmig-assessment.exe / qmig-assessment

Verify Setup

Windows

qmig-assessment.exe -help

Linux

Warning

On Linux, make binaries executable before first run

chmod +x qmig-assessment
qmig-assessment -help

Universal Parameters

These parameters are used for extraction commands:

Parameter Description Default
-type Mode selector: set to extraction Required
-host Database hostname or IP address localhost
-port Database listener port Platform default
-user Database username Required
-password Database password Required
-service Service/Database name Required
-schema Schema(s) to process - single name, comma-separated, or all Required
-output Custom output filename Auto-generated
-output-format Extraction output mode: single or separate single
-workers Parallel workers (1-10) 5
-timeout Query timeout in minutes 30
-resume Resume from last checkpoint false
-force Delete checkpoint and restart fresh false

Note

Parameters may vary slightly by source platform. Always run -help on the selected executable first.

Mode 1 - Extraction

Extraction mode exports DDL (CREATE statements) for all schema objects to .sql files. Use this first to capture the full source schema definition ahead of conversion.

Output Structure

output/<schema>_extraction_<timestamp>.sql

output/_extraction_<timestamp>/
├── <schema>
|    ├── tables/
|    ├── views/
|    ├── procedures/
|    ├── functions/
|    ├── packages/
|    ├── triggers/
|    ├── sequences/
|    └── constraints/
└── <schema>_extraction_<timestamp>.zip

Extraction Commands

Note

On Linux, use the same commands with binaries without .exe (for example, qmig-assessment instead of qmig-assessment.exe).

Single file output:

qmig-assessment.exe -type extraction -host dbserver -port 1521 -service PROD -user admin -password secret -schema SALES -output-format single

Separate directory output:

qmig-assessment.exe -type extraction -host dbserver -port 1521 -service PROD -user admin -password secret -schema SALES -output-format separate

Troubleshooting

Connection Issues

Error: ORA-12514: TNS:listener does not currently know of service requested

Solution: Verify the -service matches the Oracle service name and the listener is running.

Error: Login failed for user (SQL Server / Sybase)

Solution: Verify credentials and ensure the account is not locked. Check that TCP/IP protocol is enabled on the target instance.

Permission Issues

Error: Access denied when querying system views

Solution: Grant the required read-only privileges for the source platform (see per-platform client guides above). For Oracle, SELECT_CATALOG_ROLE covers most requirements.

Checkpoint Issues

Error: Checkpoint corrupted or stale checkpoint detected

Solution: Use -force to delete the checkpoint and restart from the beginning: 

qmig-assessment.exe -host dbserver -service PROD -user admin -password secret -schema SALES -force

Next Steps

After completing extraction:

  1. Use the extracted DDL files as input for QMigrator TryNow
  2. Review the extracted DDL for any platform-specific syntax
  3. Identify objects requiring manual conversion or remediation
  4. Plan resource and effort allocation based on object counts
  5. Contact the QMigrator team for migration planning and support