https://support.ispirer.com/ 2026-06-27T08:29:50+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2026-06-04T09:03:57+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/clone-the-project?rev=1780563837&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial How to Clone the Project SQLWays allows you to clone projects. Copying a project includes the following: * Duplicate the project configuration * Duplicate “Settings” (Options, Mappings) * Duplicate “Selected Objects” To make a copy of an existing project, go to the Home page. From the list of projects, select the one you want to clone. In the drop-down menu, click text/html 2026-03-17T14:25:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/data-extraction?rev=1773757555&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Extract Piece of Data Using Conditions Sometimes you can encounter the situation when you need to migrate only a piece of data or a data cut and you know the conditions, on which this piece of data can be defined. There is a feature in the SQLWays Legacy tool that allows to control the data that should be migrated. And the user can set such conditions for each table if required. text/html 2025-06-03T15:20:03+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/data-scn-extraction?rev=1748964003&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Extract Data Using SCN in SQLWays SCN (System Change Number) is a parameter that is used in Oracle database to control transactional consistency and version control of data. The SCN is an integer value that is incremented with every change in the database. text/html 2025-06-03T15:20:04+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/database-connection?rev=1748964004&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Set Up Database Connection An ODBC connection to the source database is required to use the Ispirer SQLWays. Please refer to the list of databases below to find your source database and follow the steps provided in the article. * Access text/html 2025-06-03T15:20:02+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/debug-collection?rev=1748964002&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Collect Debug Information about Migration Process Ispirer Toolkit collects some debug information during the migration process. The information can be useful in determining how the migration process was performed to find sources of error, if any. text/html 2026-03-18T09:51:12+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/decimal-point-change-web?rev=1773827472&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Change Decimal Point Character 1. In SQLWays. Go over the wizard to page 'Settings', add the option DECIMAL_POINT for section [Data] with the character which you need ('.'(dot ) or ','(comma)). 2. In SQLWays Command Line. Set a DecPoint value in the command line. Use the following syntax: text/html 2026-03-18T09:42:27+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/decimal-point-change?rev=1773826947&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Change Decimal Point Character 1. In SQLWays Legacy. Go over the wizard to page “Conversion Options”, select “Tables” in the object's tree, open the tab “Data” with “Formats” item in dropdown list. Change the character in the text/html 2026-06-04T09:11:40+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/edit-the-project?rev=1780564300&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial How to Edit the Project SQLWays allows you to edit projects. To modify an existing project, go to the Home page. Find the project you need, and in the drop-down menu, click Edit. Make the necessary changes. Next, check the connection to the source and target databases. text/html 2025-06-03T15:20:00+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/exclude-idx-and-constr?rev=1748964000&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Exclude All Indexes and Constraints Managing option settings in Ispirer SQLWays allows you to customize the behavior of the conversion. For example, you can exclude the creation of indexes and constrains during table creation. First of all, you should set up text/html 2026-03-17T14:23:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/expert-mode?rev=1773757434&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Use SQLWays Legacy in Expert Mode Over the more than 25-year history of the Ispirer Toolkit 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 Expert Mode in the text/html 2025-06-03T15:19:58+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/export-file-formats?rev=1748963998&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Which Export File Formats are Supported by SQLWays SQLWays exports data from the source database to the UTF8 text files (export files). Depending on the selected target database, the most suitable export file formats for data transferring are: text/html 2025-05-07T12:41:41+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/how_to_improve_the_conversion_speed?rev=1746621701&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Improve The Conversion Speed As for our approach to database migration, we follow a structured methodology, which is shown in the screenshot below: Our process involves migrating the schema first, followed by the data. You can find more detailed information about this approach in the following article: text/html 2025-06-11T17:20:27+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/how_to_schedule_daily_data_upload_etl?rev=1749662427&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Schedule Daily Data Upload for Windows (ETL) Setting up conversion Using "Data Cut" condition 1) Select all the required tables for conversion: 2) Uncheck the “Generate DDL” option (the table should already be converted): text/html 2025-05-07T10:52:35+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/how_to_test_license_server_avaliability?rev=1746615155&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Test License Server Availability To register and use an online license, access to the Ispirer server is required. License Check License validation is performed via an HTTPS POST request to: https://lsp.ispirer.net This means the following network routes must be allowed: text/html 2026-05-07T05:52:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/large-tables-migration-web?rev=1778133136&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Optimize Migration of Large Tables To reduce migration time and speed up the migration process you can split the data migration into parts and run them simultaneously in our tool. This can be done with Using Data Options Using Data Options text/html 2026-03-17T09:48:34+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/large-tables-migration?rev=1773740914&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Optimize Migration of Large Tables There are several ways to reduce migration time and speed up the migration process. * If there have been no problems during the export you can turn off trace mode. Thus there will be no trace generation which will help to reduce migration time. text/html 2025-08-07T07:24:21+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/migration-in-command-line?rev=1754551461&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Convert and Import Database in Command Line Mode Ispirer Toolkit allows you to convert and load converted database via command line or shell script. Database Conversion First of all we need to open a command line window by running Start text/html 2026-04-27T12:25:10+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/migration-schedule?rev=1777292710&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Schedule Migration Process Legacy import approach In our tool the new import mechanism was introduced to improve stability and scalability of the import process however, we have retained the option of using the legacy approach. To enable the legacy mechanism, the options set to the following values are used: [_WZD_COMMON] text/html 2026-03-18T09:10:56+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/migration-to-existing-database-web?rev=1773825056&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Migrate Data into Existing Database How to Overwrite Existing Table Structure If you want to overwrite the table definitions, you can specify GENERATE_DROP_STATEMENTS_WZD option of section [_WZD_COMMON] with 'Yes' value in SQLWays. How to Load Data into Existing Table Structure text/html 2026-03-18T08:09:46+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/migration-to-existing-database?rev=1773821386&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Migrate Data into Existing Database How to Overwrite Existing Table Structure If you want to overwrite the table definitions, you can specify generate DROP TABLE statements option in SQLWays Legacy. Please see the Generate Drop Table Statements option. How to Load Data into Existing Table Structure text/html 2026-03-18T11:34:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/name-mapping-change-web?rev=1773833678&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Change Objects Names During Migration Ispirer Toolkit allows to change objects names during the migration. Change Names Mapping in SQLWays To modify object name mappings, please open the 'Settings' page in SQLWays and navigate to the 'Name Mapping' → 'Object Names' tab. Expand the required object type and make the necessary changes in the table on the right-hand pane. text/html 2025-06-03T15:19:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/name-mapping-change?rev=1748963995&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Change Objects Names During Migration Ispirer Toolkit allows to change objects names during the migration. There are 2 ways to do this: * To change names mapping in Ispirer SQLWays * To change names mapping using project file Change Names Mapping in Ispirer SQLWays text/html 2025-06-03T15:19:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/one-script-ddl?rev=1748963994&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Consolidate All Scripts into One .sql File During the migration process, our tool creates a scope of ddl files for each object. These files are located in the Export directory. There is also an option to collect all these ddls into one script file. text/html 2026-03-16T09:09:41+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/parallel-mode-web?rev=1773652181&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Run Ispirer SQLWays in Parallel Mode When Can Parallel Mode Be Useful? Running the SQLWays tool in a parallel mode can be beneficial in the following cases: * When migrating a huge database with a number of sql objects and data * text/html 2026-03-17T14:27:17+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/parallel-mode?rev=1773757637&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Run SQLWays Legacy in Parallel Mode When Can Parallel Mode Be Useful? Running the SQLWays Legacy tool in a parallel mode can be beneficial in the following cases: * When migrating a huge database with a number of sql objects and data text/html 2026-04-17T13:47:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/perform-import?rev=1776433674&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Perform Import Ispirer SQLWays is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory. For more details on how to perform import, see the articles for each database below. text/html 2026-03-18T14:50:01+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/postgresql-ssl-connection-web?rev=1773845401&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial How to Connect to PostgreSQL Using SSL When migrating your source database into PostgreSQL or My SQL you may need to have a possibility to connect to the target database using SSL connection. For that purpose SQLWays has a set of options that allows to use SSL connection. text/html 2026-03-18T11:39:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/postgresql-ssl-connection?rev=1773833999&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial How to Connect to PostgreSQL Using SSL When migrating your source database into PostgreSQL or MySQL you may need to have a possibility to connect to the target database using SSL connection. For that purpose SQLWays Legacy has a set of options that allows to use SSL connection. text/html 2026-03-17T11:12:48+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/schema-and-data-migration-web?rev=1773745968&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Optimize Migration of Schema and Data To optimize the migration process, we recommend splitting the conversion into multiple threads using the following approach: * (Project 1) In the first project of the tool, select all the tables (and other objects (views, functions, etc.) if any) that you want to convert. text/html 2026-03-17T10:52:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/schema-and-data-migration?rev=1773744774&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Optimize Migration of Schema and Data To optimize the migration process, we recommend splitting the conversion into multiple threads using the following approach: * (Instance 1) In the first instance of the tool, select all the tables (and other objects (views, functions, etc.) if any) that you want to convert. text/html 2025-05-27T13:46:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/script-migration-in-command-line?rev=1748353586&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Convert SQL Scripts in Command Line Mode First of all we need to open a command line window by running Start → Run → cmd.exe Prepare Command Line Using tool for script conversion will help you to convert separate files with SQL code inside. text/html 2025-05-30T15:39:44+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/selection-object-automation?rev=1748619584&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Automate Selection of Objects If you need to select a large number of objects for conversion, we have the ability to automate the selection in several ways. 1. On the Object Selection page, click the “Filter objects” button. In the window that opens, click text/html 2026-03-17T14:25:22+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/set-options-sqlways-wizard?rev=1773757522&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Set Options in SQLWays Legacy In order to set an option in the SQLWays Legacy tool, you need to: * Enable expert mode in tool * On the “Summary page” you need to click on the “Edit Option FIle” button: * The opened .ini file contains all the options that our tool uses for conversion process. These options are located in different sections: [COMMON], [DDL], [Oracle] and other. In order to set one or another option, you ne… text/html 2023-11-27T13:29:40+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/sql-code-testing?rev=1701091780&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Test Converted SQL Code This article describes SQLWays testing options, their usage and output generated. The databases supported are: Sybase Adaptive Server Enterprise, Oracle and Microsoft SQL Server. Option TEST There are two ways of specifying the option TEST when running SQLWays: text/html 2025-06-03T15:19:49+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/sqlways-wizard-query?rev=1748963989&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Run Query in SQLWays In order to run a query in the SQLWays tool, you need: • Enable expert mode in the tool • On the “Objects Selection” tab you need to click on the “Specify Objects” and select “Test Query”: • In the window that opens, paste the query you want to run and click on the “Execute” button: text/html 2025-06-03T15:19:47+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/table-split?rev=1748963987&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Split Table Structure into Several Parts Sometimes when migrating from one database to another, we may face the situation when in the source database there is a table with a greater number of columns than the maximum number of columns allowed in the target database. Or according to the optimization process you decided to split a table into several tables. text/html 2026-03-17T14:24:48+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/trace-mode?rev=1773757488&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Run Conversion in Trace Mode There is a possibility to run the conversion in “Trace Mode” in the SQLWays Legacy tool. To enable “Trace Mode” conversion just check the option “Trace Mode” on the “Conversion Options” page, on text/html 2025-05-30T12:54:09+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/use-query?rev=1748609649&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Extract Piece of Data Based on Data from Other Tables Using Use Query In addition to selecting objects from the object tree, our tool has the ability to retrieve data from the source database using the SELECT statement. To implement this action on the Select Object page, you can configure text/html 2026-03-17T14:13:56+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/work-with-parsers-web?rev=1773756836&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Work with 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. text/html 2025-05-30T15:12:49+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/ispirer-toolkit-faq/work-with-parsers?rev=1748617969&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial How to Work with 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.