Products


Ispirer's business is grounded in a cutting-edge migration tool SQLWays, which allows highly accurate migrations to be performed automatically. SQLWays has the ability to take full control of the entire migration cycle providing a high level of automation of all migration phases.

SQLWays migrates stored procedures, functions, triggers, views, database schema (DDL) and data. The code migration speed is approximately 100 lines per second, allowing millions of Lines of Code to be migrated in a few hours! The tool is especially useful when you need to transfer large data volumes over a short or limited period of time. The data conversion speed can be tuned up to 50 - 100 GB per hour! Typically our migration experts conduct a comprehensive evaluation of our clients' migration needs to determine how best to tune the SQLWays tool in support of the project requirements and goals.

We are committed to providing automated conversion generating readable and maintainable code, using best practices within the target platform rather than just emulating the legacy system.

  • Database Migration

    SQLWays migrates the entire databases including data, database schema, triggers and scripts between major database management systems (DBMS). The tool supports the largest number of databases including all the leading and most legacy databases. Typically all versions of the SQL DBMS are supported - from the most recent releases to legacy versions. We are constantly extending the SQLWays toolset, thus the list of supported databases is always being expanded.. Supported source and target databases include Oracle, SQL Server, IBM DB2, MySQL, SchoonerSQL, Sybase, Informix, HP Neoview, Teradata, Netezza and others. Learn More...

  • Embedded SQL/Database API Conversion

    SQLWays automatically performs comprehensive assessment and migration of embedded SQL statements and database API in various applications. It supports conversions between ODBC, Oracle OCI, Oracle Pro*C, Sybase CT/LIB and other interfaces. SQLWays automates the entire migration of embedded SQL and database API, which allows it to dramatically decrease conversion risks and reduce time spent on the project. Learn More...

  • Application Conversion

    SQLWays can automatically convert applications between various platforms and programming languages. It is possible to convert applications from PL/SQL to Java, Progress ABL/4GL, Informix 4GL to C#, VB to C#/VB.NET and others. Typically SQLWays is able to automate in excess of 95% of an application business logic, user interface and reports. Learn More...

Additional Tools

Ispirer has many years of expertise of providing migration services. SQLWays has evolved over the years and now we are pleased to offer exclusive accessory tools. Specifically these tools are:

Comparator - a separate tool with a comparison function. After the conversion is finished, the Comparator tool allows you to compare source and target databases and see if there are any differences between them. Comparison options include comparison by table name, by table column count, by table column names, by table row count, etc. It can be passed to any available sort method you choose. With the help of this tool you will be able to see if anything has been missed or if there is any inconsistency in your resultant data. More information about this tool you can find on the page SQLWays Comparator.

Replicator - a replication tool designed for replication scripts that are created in SQLWays. SQLWays builds additional objects (triggers and replication tables) in a source database. From the point of creation triggers trace the information about rows of data that were added, changed or deleted. All this information is stored in those replication tables. The Replicator tool addresses these replication tables and upgrades the target database in accordance with changes made to the source database.

You can see the non-interactive demo for the SQLWays Replicator tool using the following link: SQLWays Replicator (online presentation)

Data migrator - a tool invented for automated data migration. This tool can be set up when you need to map data from tables into text format. The Data Migrator tool provides an easy means of managing this process. This cross-platform tool currently has a fixed number of options and can be extended upon further request.

Power Builder Source Extractor - developed especially for Sybase PowerBuilder, this tool helps SQLWays convert PowerBuilder applications at the level of scripts. Source Extractor allows the extraction of Powerbuilder scripts directly from the PBL files. Once complete the PowerBuilder Source Extractor places all scripts into a separate folder. Later these extracted scripts can be converted into new scripts with the help of SQLWays and migrated into another application.

You can see the non-interactive demo for the PBExtractor tool using the following link: PowerBuilder Source Extractor (online presentation)

If you are interested in having us develop any of these accessories in support of your migration project please feel free to Contact Us.

Our Approach

Our migration experts have expert knowledge in delivering migration services and solutions to our customers. We are dedicated to our clients and value their time. We are confident that once you see our technology in action you will see its value within your project.

If you would like to see a free online presentation of the SQLWays toolset, please click here.

If you would like to get a quote on the purchase of SQLWays, please click here.

If learn more about our approach at Engagement Process page, please click here.

 
online presentation
live presentation
download sqlways free express version
download a demo
purchase license
SQLWays
Target Databases
  • Oracle
  • Sybase
  • SQL Server
  • Informix
  • IBM DB2
  • Netezza
  • MySQL
  • Teradata
  • SAP HANA
  • HP Neoview
  • PostgreSQL
  • HP NonStop SQL/MX
     Version details
Source Databases
  • Oracle
  • Informix
  • SQL Server
  • HP Neoview
  • IBM DB2
  • Progress
  • MySQL
  • Teradata
  • PostgreSQL
  • Netezza
  • Sybase
  • Interbase/Firebird
     Version details
Testimonials
September 1, 2014Continental Tire the Americas, LLC, United States
DB2 to Oracle Migration

"Recently it became necessary to migrate our existing DB2 database into an Oracle environment. Our migration required that all tables, data, triggers and functions...

...

August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including PowerBuilder migration)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to grow rapidly and...

...

Case Studies
August 19, 2014DB2 z/OS to Oracle Migration, United States

Our client was a Group of Companies from the United Stated providing Steel Mill, Aggregate and Asphalt products for more than 90 years.

...

August 19, 2014PowerBuilder to C# Conversion, Canada

Our client was a leader and innovator in integrated pharmacy technology from Canada. He addressed to Ispirer in order to perform an application migration.

...

Events