Skip to content

Assessment Tools

Overview

QMigrator Assessment Tools are secure, agentless executables that connect directly to source databases to collect metadata and generate migration readiness reports. They require no agent installation, no Docker, and no database client, making them suitable for restricted or air-gapped environments. The assessment tool generates comprehensive Excel reports covering object inventories, compatibility issues, and server metrics.

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 assessment commands:

Parameter Description Default
-type Mode selector: set to assessment assessment
-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
-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
-filter Object filters to include (platform-specific; see Filter Reference) Optional

Note

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

Assessment

Assessment mode collects schema metadata and generates a structured Excel report (.xlsx) covering migration readiness, object inventories, compatibility issues, and server metrics.

Filter Reference

Filter Code Objects Covered
all ALL Everything (default)
code CO Packages, Procedures, Functions, Triggers, Types, Synonyms
storage SO Tables, Views, Indexes, Sequences, Partitions
constraints CON Primary Keys, Foreign Keys, Unique, Check, Not Null
server SRV Database Version, CPU, Memory, Tablespaces
users USR Users, Roles, Privileges

Report Output

The tool generates an Excel workbook in the output/ directory containing:

  • Summary: Object counts, schema size, database version
  • Code Objects: Procedures, functions, triggers, and packages with status
  • Storage Objects: Tables, indexes, sequences, and partitions
  • Constraints: PK, FK, unique, and check constraint details
  • Server Information: Version, memory, CPU, tablespaces
  • Users & Privileges: User accounts, roles, and privilege mappings
  • Compatibility Issues: Platform-specific features requiring conversion
  • Migration Recommendations: Suggested actions for successful migration

Commands

Note

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

Full Assessment:

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

Filtered Assessment:

qmig-assessment.exe -host dbserver -port 1521 -service PROD -user admin -password secret -schema SALES -filter code

Multiple Schemas:

qmig-assessment.exe -host dbserver -port 1521 -service PROD -user admin -password secret -schema HR,SALES,FINANCE

Resume Interrupted Assessment: 

qmig-assessment.exe -host dbserver -port 1521 -service PROD -user admin -password secret -schema SALES -resume

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 assessment:

  1. Review the Excel report for compatibility issues and incompatible objects
  2. Identify objects requiring manual remediation or conversion logic
  3. Plan resource and effort allocation based on object counts and complexity
  4. Use assessment findings to guide extraction and migration strategy
  5. Contact the QMigrator team for migration planning and support