Skip to content

Agentless Assessment

Overview

The QMigrator Agentless Assessment tools are secure, executable-based utilities designed to assess source databases for migration readiness. They run without installing agents or Docker, making them suitable for restricted environments. The tools collect read-only metadata and generate assessment reports for compatibility analysis, sizing, and migration planning.

Prerequisites

Before executing the assessment tool, ensure the following:

  • Source database is reachable from the machine where the tool is executed
  • Database listener/service is running and accepting connections
  • Database user has read-only privileges on required system views
  • Supported Operating Systems: Windows or Linux
  • Run commands from the downloaded folder

Installation & Setup

Download Tools

Download the executable for your source platform:

oracle Oracle qmig-assessment.exe

SQL Server qmig-sql-assessment.exe

Use the corresponding Linux binary name in Linux environments.

Verify Setup

Test the tool is working:

qmig-assessment.exe -help
qmig-sql-assessment.exe -help

qmig-assessment -help
qmig-sql-assessment -help

Command Syntax

<assessment-tool>.exe [OPTIONS]

<assessment-tool> [OPTIONS]

Available Parameters

Parameter Description Example
-host Database hostname or IP address dbserver.example.com
-port Database listener port 1521
-service Service or database name PROD
-user Database username admin
-password Oracle database password secret123
-schema Schema to be assessed SALES
-filter Comma-separated object types to assess code,storage
-output Custom output filename sales_report.xlsx
-resume Resume interrupted assessment from checkpoint N/A

Note

Parameters can vary by source platform. Always run -help for the selected executable before execution.

Assessment Execution

Full Assessment

Assess all supported objects including code, storage, constraints, users, and server information.

Info

On Linux, use the Linux binary (qmig-assessment or qmig-sql-assessment) instead of the .exe files.

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

qmig-sql-assessment.exe -host dbserver -port 1433 -user admin -password secret -schema SALES

Filtered Object Assessment

Assess only specific object types to reduce execution time.

Filter Reference

Use the -filter parameter to assess specific object categories.

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

Single Filter

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

qmig-assessment -host dbserver -service PROD -user admin -password secret -schema SALES -filter code

Multiple Filters

qmig-assessment.exe -host dbserver -service PROD -user admin -password secret -schema SALES -filter "code,storage,constraints"

qmig-assessment -host dbserver -service PROD -user admin -password secret -schema SALES -filter "code,storage,constraints"

Custom Output Filename

Override the default output filename for better organization.

qmig-assessment.exe -host dbserver -service PROD -user admin -password secret -schema SALES -output sales_migration_report.xlsx

qmig-assessment -host dbserver -service PROD -user admin -password secret -schema SALES -output sales_migration_report.xlsx

Checkpoint & Resume

The tool creates checkpoint files to enable resuming from the point of failure or interrupted assessments.

Checkpoint Process

  1. During Assessment: Checkpoint file created in output/ folder as a temporary file
  2. On Success: Checkpoint file is automatically deleted
  3. On Failure: Checkpoint file is preserved for resume capability

Resume Interrupted Assessment

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

qmig-assessment -host dbserver -service PROD -user admin -password secret -schema SALES -resume

Resume Best Practice

Use the -resume flag with the same host, service, user, and schema parameters to continue from where the assessment stopped.

Output Report

The assessment generates an Excel file containing:

  • Summary Sheet: High-level migration readiness metrics
  • Code Objects: Stored procedures, functions, triggers, and packages
  • Storage Objects: Tables, indexes, sequences, and partitions
  • Constraints: Primary keys, foreign keys, and constraint details
  • Server Information: Database version, resource allocation, and tablespaces
  • User & Privileges: User accounts, roles, and privilege mappings
  • Compatibility Issues: Objects requiring manual conversion or remediation
  • Migration Recommendations: Suggested actions for successful migration

Troubleshooting

Connection Issues

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

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

Permission Issues

Error: Access denied when querying system views

Solution: Ensure the database user has SELECT_CATALOG_ROLE or equivalent read-only privileges:

GRANT SELECT_CATALOG_ROLE TO <username>;

Next Steps

After completing the assessment:

  1. Review the generated Excel report for compatibility issues
  2. Identify objects requiring manual remediation
  3. Plan resource allocation based on server information
  4. Create a migration strategy using assessment findings
  5. Contact QMigrator team for detailed migration planning