Differences between script-based conversion (CodeWays) and direct database connection (SQLWays)

Reference: SQLWays Database Migration Guide

Description: SQLWays is a robust, end-to-end migration tool designed for full-scale database migrations.

It connects directly to the source databases using ODBC.
This allows it to analyze the source environment in depth, extract object definitions, and assess interdependencies, which significantly improves the accuracy and completeness of the conversion process.

Key Features:

• Connects to the source database via ODBC to retrieve schema definitions and metadata.
• Detects and includes dependent objects automatically, even if they weren’t initially selected, ensuring consistency.
• Converts objects into platform-specific SQL scripts and other relevant files.
• Supports automatic or manual import into the target PostgreSQL environment.
• Allows modification of the generated scripts prior to import, giving you control and flexibility.

Process Breakdown:

1. Step 1 – Conversion: Extracts and converts schema and data objects into .sql and .txt files.
2. Step 2 – Import: Executes the converted scripts against the target PostgreSQL database.

Advantages:

• Ensures high fidelity of migration due to detailed analysis of dependencies.
• Facilitates end-to-end automation with optional manual adjustments.
• Supports both schema and data migration.
• Useful for larger, integrated environments requiring high accuracy.

Limitations:

• Requires proper ODBC connectivity to the source database.

Read more on our website: https://www.ispirer.com/products/sqlways-database-migration

Reference: CodeWays Script Conversion Guide

Description: CodeWays is a tool focused exclusively on converting standalone SQL scripts from one dialect to another.

It does not require or establish any connection to the source or target databases, and works entirely offline with the script files provided.

Key Features:

• Converts existing Oracle SQL scripts to PostgreSQL syntax.
• Supports batch processing of files.
• Lightweight and easy to configure.
• No dependency on source or target environment access.

Advantages:

• Quick and easy to use for converting discrete scripts.
• Ideal for offline scenarios or when database access is not possible.
• Suitable for isolated functions, procedures, or packages.

Limitations:

• Does not analyze dependencies between objects.
• No data extraction or import functionality.
• Best suited for code-only migration use cases.

Read more on our website: https://www.ispirer.com/products/codeways-app-conversion

Database Migration Guide
CodeWays Script Conversion Guide

More Tips and Tricks

If you have any questions or face any difficulties, please contact our support team at support@ispirer.com