https://support.ispirer.com/ 2026-04-21T10:00:48+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2026-03-05T14:09:48+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/ai-assistant?rev=1772719788&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial AI-Assistant in SQLWays Legacy Ispirer introduced AI-assistant feature in SQLWays Legacy that can be used to improve generated results of code conversion and save huge amount time on fixing possible issues for developers that works directly with the tool. text/html 2026-03-05T14:09:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/before_and_after_data_import?rev=1772719799&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Using SQL scripts before and after migration As part of the improved functionality of the data migration tool, two optional options have been added that will allow you to manage the data import process more flexibly by automating pre- and post-import operations. They allow you to specify SQL scripts to be executed before and after data import. This article describes the new options and the process of their configuration in detail. text/html 2026-02-24T15:26:07+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/case-sensitive-schema-web?rev=1771946767&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Preserving case-sensitive schema names Regarding the need to preserve the original case of schema names (by quoting them in the object declarations), this behavior can be achieved without any manual modifications to the generated scripts. Please follow the steps below: text/html 2026-02-24T14:17:42+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/conversion-results-web?rev=1771942662&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Conversion Results The complexity of a database migration project depends on multiple factors, including: * code complexity * source and target technologies * application programming language SQLWays provides a high level of SQL code conversion. Additionally, the tool can be customized and its conversion rules adjusted to meet the specific requirements of each project. However, it is important to understand that no tool can f… text/html 2026-03-05T14:08:51+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/conversion-results?rev=1772719731&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: How to Work with Conversion Results The complexity of a migration project depends on many parameters - code complexity, source and target technologies, application language. The migration process is divided into 3 stages - direct migration of SQL code and data, testing, making changes to the application that works with the database. SQLWays Legacy helps you implement database migration processes. text/html 2026-03-05T14:06:13+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/conversion-scope?rev=1772719573&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Independent Conversion Scope The easiest and safest option for converting your project is to choose the full scope for conversion. In this case, you will select all objects, and there will be no errors during import related to the fact that some object are not in the database. Our tool always loads the converted objects in the required order parent objects will always be loaded before child ones. Naturally, even here there can… text/html 2026-02-24T15:31:58+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/create-new-proj-web?rev=1771947118&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Creating New Migration Project Creating a new migration project is the first and mandatory step before starting any conversion or migration activities in SQLWays. A project defines the source and target technologies, connection parameters, and overall migration scope. text/html 2026-03-06T13:30:56+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/cross-database-references-migr?rev=1772803856&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays ⬝ Migrating cross-database references Approaches As you know, PostgreSQL, unlike Sybase and MS SQL Server, does not support native cross-database references. When planning a migration, there are several possible approaches to handling databases that are referenced across database boundaries: text/html 2026-02-24T14:15:05+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/data-extraction-web?rev=1771942505&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Data Extraction This article explains how to configure Data Extraction in the new SQLWays tool.  Data extraction is used when you want the tool to read (extract) data from the source database and generate output files for subsequent loading into the target database, or when you want to run a text/html 2026-03-05T14:07:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/data-extraction?rev=1772719658&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLways Legacy: Data Extraction The main focus of our tool is the migration of schema and business logic objects. In terms of the level of schema conversion for most areas, we have no equal. However, the tool is also suitable for data migration in most scenarios. We are actively developing and implementing new algorithms for data migration, which allows us to increase the speed for migrating within popular directions. text/html 2026-02-24T14:16:36+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/data-type-mapping-web?rev=1771942596&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Data Type Mapping (Local & Global) SQLWays supports flexible data type mapping, allowing column data types to be modified either globally across the entire database — including tables, variables, and parameters — or locally for selected tables only. To accommodate different migration strategies and levels of control, the tool provides two distinct data type mapping approaches. The following sections describe global data type mapping … text/html 2026-03-05T14:08:14+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/data-type-mapping?rev=1772719694&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Data Type Mapping SQLWays Legacy allows you to change the column type for some tables or all tables and database variables and parameters at the same time. It can be especially efficient for the following cases. For example, the smallint type in PostgreSQL (smallint is a two-byte signed integer) requires an explicit cast for numbers or when another integer variable is assigned to the smallint one. If you replace all smalli… text/html 2026-03-10T12:32:40+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/diff-between-script-and-database-conv?rev=1773145960&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Differences between script-based conversion (CodeWays) and direct database connection (SQLWays) SQLWays – Migration via Database Connection Reference: SQLWays Database Migration Guide Description: SQLWays is a robust, end-to-end migration tool designed for full-scale database migrations. text/html 2026-03-05T14:04:15+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/expert-mode?rev=1772719455&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Expert Mode Over the more than 25-year history of the SQLWays Legacy development, a huge number of options and features have been added to it, with which you can improve the conversion result. By default, we have hidden most of these options from customers to make it easier for beginners to navigate. However, when you enable text/html 2026-03-05T14:08:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/import-order?rev=1772719718&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Import Configuration The migration process in SQLWays is divided into 2 stages - object conversion (including data extraction) and import (loading objects into the target database). By default, the tool determines order in which objects will be loaded into the target database. It is able to determine dependencies between objects and always loads parent objects before child ones. text/html 2026-02-24T14:18:27+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/mig-status-manipulations-web?rev=1771942707&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Migration Status manipulations On the Dashboard tab of the SQLWays tool, you can see a tree of objects showing the resulting migration statuses, as well as cards summarizing the migration results. Once each migration phase is completed, the status of the phase is displayed: text/html 2026-03-05T14:09:37+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/mig-status-manipulations?rev=1772719777&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Migration Status Manipulations On the Migration Execution page, you can see a tree of objects with the resulting migration statuses: Once each migration phase is completed, the status of the phase is displayed: Here you can open for editing the object sql.file created at the Export phase. You can make adjustments and save your changes before starting or restarting the Import phase: text/html 2026-02-24T15:26:33+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/object-import-order-web?rev=1771946793&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays : Order of Object Import In the SQLWays we can influence the order of migration execution. There are three possible import orders, all of which affect the import of tables (DDL, data, indexes, and constraints): * Fast: DDL → Data → Constraints → Indexes text/html 2026-03-05T11:03:19+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/object-import-order?rev=1772708599&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Order of Object Import In the SQLWays Legacy tool we can influence the order of migration execution. So if we would like to have the following order: * create tables * load data * create indexes, etc. We should choose the option FAST in SQLWays Legacy as shown on the screenshot below: text/html 2026-03-05T14:10:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/old_new_import?rev=1772719816&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial New Import approach Starting from version 10.73.8047 of SQLWays Legacy, we implemented a new approach of import for following Target databases: * EnterpriseDB PPA * Greenplum * MariaDB * MSSQL * MySQL * Oracle * PostgreSQL * SinglestoreDB. text/html 2026-02-24T15:32:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/parallel-mode-web?rev=1771947146&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Running SQLWays in Parallel Mode When Parallel Mode Is Useful? Running SQLWays in parallel mode can be advantageous in the following scenarios: * migrating a large database containing a significant number of SQL objects and substantial volumes of data text/html 2026-02-24T15:27:35+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/post-conversion-process-web?rev=1771946855&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Post-Conversion Editing and Re-Import of Objects After the conversion of the objects, the process may be considered incomplete: an error may occur during import, or the applied conversion approach may not meet the project requirements. text/html 2026-02-24T15:26:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/preserving-source-database-case-web?rev=1771946819&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Preserving Source Database Case for PostgreSQL as Target PostgreSQL automatically converts identifiers to lowercase. As a result, object names such as ‘Menu’ in MS SQL Server are converted to ‘menu’ when not explicitly quoted during the conversion process. text/html 2026-04-01T10:56:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/project-directory-web?rev=1775041014&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Project Directory To run a successful migration project, it is essential to understand how the Project Directory works. Although many beginners overlook this setting, it plays a critical role in the migration workflow and should be clearly understood before you start working with the tool. text/html 2026-03-05T14:05:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/project-directory?rev=1772719538&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Project Directory If you want to run a successful migration project, you need to understand how the project directory works. Most beginners skip this setting, but it is crucial to understand it before start working with it. Migration Project text/html 2026-02-24T15:21:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/schema-and-data-migration-web?rev=1771946519&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Optimizing Schema and Data Migration To optimize the migration process, we recommend dividing the conversion into multiple threads by following the steps below: * (Project 1) For the first migration project, select all the tables (as well as any other objects, such as views, functions, etc.) that you intend to convert. text/html 2026-02-24T15:32:53+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/schema-mapping-web?rev=1771947173&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Schema Mapping Schema Mapping defines how source schema names are handled and transformed in the generated target code. Proper schema mapping is an important part of migration projects, especially when migrating to environments with different schema structures, naming conventions, or security models. text/html 2026-03-05T14:07:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/schema-mapping?rev=1772719675&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Schema Mapping Each database has a different organization structure. For example, in Oracle, the schema and the user are the same, PG databases allow to create your own schemas in each database, in MySQL the database and the schema are the same. It is often difficult to understand how to change the organization of the database during the conversion process. text/html 2026-02-24T15:33:15+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/search-filter-web?rev=1771947195&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Search Filter on the Source Objects Panel The Search Filter on the Source Objects Panel of SQLWays is used to quickly locate source database objects in projects with a large number of schemas and objects. The filter searches for the entered sequence of characters in text/html 2026-03-05T14:09:05+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/search-filter?rev=1772719745&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Search Filter on the Source Objects Panel In the SQLWays Legacy tool we can restrict the list objects for displaying on the Objects Selection page. To add a filter you should set up some filters by pressing on the “Filter objects” button. text/html 2026-02-24T15:31:13+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/setting-options-web?rev=1771947073&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Setting Options This article provides a high-level overview of how conversion options are organized and managed in SQLWays. It explains the purpose of option sections, the role of individual options, and the general principles of configuring and extending them to control the behavior of conversion rules. text/html 2026-02-24T14:17:09+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/structure-changes-web?rev=1771942629&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Structure Changes Migration is the best reason for any changes in the database, including refactoring and getting rid of unnecessary objects/data. The tool has a huge number of options that allow you to make automatic changes during conversion. text/html 2026-03-05T14:08:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/structure-changes?rev=1772719706&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Structure Changes Migration is the best reason for any changes in the database, including refactoring, getting rid of unnecessary objects / data. The tool has a huge number of options that allow you to make automatic changes during conversion. text/html 2026-02-24T15:25:42+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/target-version-web?rev=1771946742&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Target Database Version SQLWays is being developed by leaps and bounds. We closely monitor all new releases of the most popular databases and try to add all new features to the tool in a timely manner. For example, let's take the MERGE statement - in text/html 2026-03-05T14:06:01+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/target-version?rev=1772719561&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Target Database Version Our tool is developing by leaps and bounds. We closely monitor all new releases of the most popular databases and try to add all new features to the tool in a timely manner. For example, let's take the MERGE statement - in the new release of PostgreSQL (version 15) MERGE support has been added. Immediately after the release, we changed the MERGE conversion for all popular sources. However, the new conv… text/html 2026-03-05T14:07:27+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/trace-mode?rev=1772719647&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays Legacy: Trace Mode As a result of the conversion, the tool creates a separate .sql file for each object with create statement. However, the question arises - how to compare the result with the source code, what was the result of the conversion with the original DDL of the object? How to unload them from the source database in order to compare with results? text/html 2026-03-12T13:25:25+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/unable-to-start-migration-service?rev=1773321925&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Unable to Start Migration Service if run SQLWays When launching the SQLWays application, the application fails to open and displays the following error: Cause This error typically occurs when the migration service is already running, blocked, or not properly initialized. Possible reasons include: text/html 2026-03-05T14:09:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/use-query?rev=1772719766&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Writing an SQL Query by Joining Multiple Source Tables and Migrating to a Single Target Table In the SQLWays tool we can migrate a query that will join several tables and import into one target table. To perform this action, we should click on text/html 2026-02-24T15:23:19+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/tips-and-tricks/work-with-parsers-web?rev=1771946599&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SQLWays: Parser Errors What is a Parser Error After the conversion process, you may see that some objects or scripts were not converted due to parser errors. It means that the conversion tool was unable to analyze the code of the object or file. In other words, some unknown statements or constructions were found inside the object or script that we are trying to convert.