Ispirer Database Migration Tool Frequently Asked Questions
1/3

The Clock Is Ticking on Sybase ASE | Watch the Session

2/3

IDM: New Way to Automate Data Migration | Watch the Session

3/3

SQLWays is Now Web-Based. Watch the Live Product Tour

Frequently Asked Questions

Here you will find answers to the most frequently asked questions about Ispirer software and services. In case you require more information, feel free to contact our support team. We’re here to help.

Want more details?

Request a consultation with our expert

Schedule a call

30 min of constructive conversation.

I need to migrate a database. How can you help me?

Ispirer's proprietary solution, SQLWays, automates the database migration process. It converts your schema — including tables, stored procedures, functions, and triggers — to your chosen target technology. You get high-level automation that minimizes manual coding, preserving your business logic and structural integrity as you migrate from legacy systems to modern environments like PostgreSQL or cloud-native databases.
SQLWays is a customizable solution. If you have unique project needs and scope, feel free to reach out for a free consultation. We will propose an optimal roadmap combining automated migration and expert services.

I need to migrate data. How can you help me?

For data migration, we offer Ispirer Data Migrator (IDM). This solution establishes a direct, high-speed connection between your source and target. It utilizes parallel processing and multithreading to move massive datasets. You experience near-zero downtime thanks to iterative sync processes that capture ongoing changes while the migration runs in the background.

I need to convert an application. How can you help me?

We breathe new life into legacy applications by converting them to modern languages and architectures. Our CodeWays solution handles the conversion of application code (such as PowerBuilder or Delphi to .NET or Java), embedded SQL statements, and database APIs. This comprehensive approach ensures your application functions correctly on the new platform without requiring a complete rewrite from scratch.
Reach out to discuss your unique migration scenario and the full range of services you might need to modernize without reinventing the wheel.

How much does Ispirer Toolkit cost?

Our pricing is license-based, license prices depend on the project size and its duration. Thus, the project price is determined only after a thorough analysis of the source database or application. For this purpose, we have free Assessment Tools that will automatically collect all the necessary information.

Does Ispirer provide a solution for replication and CDC?

Yes. IDM utilizes sophisticated Change Data Capture (CDC) logic through its iterative migration process. It captures inserts, updates, and deletes on the Oracle side using modification statistics and flashback queries. By repeatedly syncing these changes in background iterations, the tool minimizes lag, replicating data in near-real-time until you are ready for the final cutover.

What technologies does Ispirer Toolkit support? Where can I check if the direction I need is supported?

Ispirer Toolkit supports a majority of legacy and modern applications and databases. You can choose the required migration direction on the Application Conversion and Database Migration pages.

What technologies does Ispirer IDM support?

IDM is a specialized solution for high-performance migrations from Oracle RDBMS (version 10 and above) to PostgreSQL RDBMS (version 14 and above). It handles large-scale projects and supports experimental hub modes for replicating data to additional targets, such as ClickHouse or secondary PostgreSQL instances.

I'm not sure which technology to migrate to. Can you help me choose the most appropriate one?

Depending on your existing database or application, our experts can provide recommendations regarding the right target technology. Contact us and we’ll answer all your queries.

Can I try Ispirer Toolkit for free?

Absolutely! To make sure you get the best experience from your trial, we’ll need some information about your project. Book a demo with our experts to discuss your migration goals, scope, and direction. This allows us to customize Ispirer Toolkit specifically for your needs.

Can I try IDM for free?

There is no free access to the IDM license. You can request a demo session through our team. During the session, we will help you figure out how IDM can fit your data migration project.

What conversion quality does Ispirer Toolkit provide?

Conversion quality depends on migration type, direction, and source code features. Nearly 100% of tables and data are converted for most directions. Approximately 75-95% of SQL code can be converted correctly by the tool. When the source code includes mostly business logic, as in the case of COBOL applications, around 70%-90% of the code can be converted automatically. For an application with a GUI, the initial conversion rate can be lower. However, in such cases, the customization of Ispirer Toolkit allows to achieve 90% of conversion.

What does Ispirer Toolkit customization mean?

Ispirer Toolkit works on the basis of thousands of built-in conversion rules. Customization means our experts can adapt these rules to your specific project needs - by creating new ones or fine-tuning existing ones.
This ensures your migration is not only more accurate and reliable but also significantly faster, with fewer manual corrections required. You can decide which improvements are needed on your own or collaborate with our specialists to identify them.
The ultimate goal of customization is to maximize the efficiency of automated migration. With tailored rules, projects often require far less time and effort - sometimes reduced by a factor of ten or more.

How to choose between Ispirer Toolkit and migration services?

If you have your own team of experts with sufficient migration expertise to successfully migrate your database or application, Ispirer Toolkit is the best option for you. It will greatly simplify your team's work and speed up the migration project. If your team lacks the necessary expertise, our migration services will be the right choice.

Do Ispirer services include refactoring, testing and performance optimization?

Yes. Our experts have accumulated extensive experience not only in database and application migration but also in other facets of software modernization and optimization.

How can I evaluate the quality of the conversion result before launching full-fledged migration?

For you to be able to evaluate the conversion quality that could be achieved in the potential migration project, we offer a Proof-of-Concept. We will migrate a small piece of your code using Ispirer Toolkit and showcase the result of migration. It would allow you to evaluate the conversion quality at a smaller scale and cost before making a purchase decision.

What databases and programming languages do you provide migration services for?

As part of the services, we work with almost all technologies, even those that are not supported by the Ispirer Toolkit. Feel free to contact our support service, even if you have not found the technology you are interested in.

How much do migration services cost?

The price of a migration project depends on your migration direction, code volume, duration, and unique features of your code. To get an estimate of your project, please, contact our support service agents.

What is the data migration speed achieved when using IDM?

IDM achieves exceptional speeds of 250 GB per hour by leveraging Foreign Data Wrappers and parallel multithreading. The tool bypasses middleware bottlenecks, reading data directly from Oracle and writing to PostgreSQL in concurrent batches. This allows you to maximize your hardware's potential, ensuring consistent high performance even for terabytes of data.
The actual speed varies depending on the architecture.

What data types does IDM support?

IDM supports the full spectrum of Oracle data types, including complex structures and BLOBs (Binary Large Objects), migrating them at full speed. During the Table Adoption phase, the tool automatically maps columns and handles data type conversions, while also offering you the flexibility to apply custom mappings for non-standard cases.

Can IDM be used in Command Line Mode?

Yes. You can use IDM in command line mode to streamline your data migration process.
The current IDM workflow also prioritizes ease of use through a comprehensive Graphical User Interface (GUI). This intuitive dashboard allows you to manage projects, configure connections, select tables, and monitor granular progress visuals without needing deep scripting expertise. You control the entire lifecycle — from creation to finalization — directly from this visual environment.

What middleware parameters are necessary to use IDM?

You need zero middleware parameters. IDM is designed as a direct-connection solution. It leverages Foreign Data Wrappers to access Oracle data in read-only mode from the PostgreSQL side. This streamlined architecture eliminates the need for intermediate software, simplifying your setup and enhancing security.

Which source databases does Ispirer Toolkit support?

Ispirer Toolkit support migration from the majority of popular databases, including Oracle, SQL Server, DB2, MySQL, and others. The full list of supported source databases is here.

Which target databases does Ispirer Toolkit support?

The toolkit support migration to the most popular target databases, including PostgreSQL, MySQL, Oracle, SQL Server and others. You can see the full list of supported target databases here.

Does Ispirer Toolkit support Sybase (SAP) databases?

Sure, Ispirer Toolkit converts Sybase ASE (SAP ASE), Sybase ASA (SAP Anywhere) and Sybase IQ (SAP IQ) with a high-quality outcome.

Does Ispirer Toolkit support DB2 migration to such platforms as iSeries and mainframe?

Yes, the toolkit supports the transition of IBM DB2 for LUW, iSeries (AS/400) and zOS (OS/390). Learn more by following this link.

Can I access your website in languages other than English?

Yes, we have websites in Spanish, Chinese, and Japanese.

Cookie icon
THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used. For more details, please read our Privacy Policy and Cookies Policy.
I Got it