Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, VB to C#, ASP to ASP.NET)

Customer

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.

Challenge

The service was complex and included:

• Migration of three database schemas from Informix to MS SQL Server

• Three PowerBuilder applications with embedded SQL migration from Informix to MS SQL Server

• Migration of an ASP site to ASP.NET with twelve Web COM components from Visual Basic to C#

Solution

The Ispirer team was able to accomplish the task within six months. The scope of the project was quite extensive and comprised migration of: more than 250 thousand tables in Informix to MS SQL Server, over 720 thousand lines of code in PowerBuilder embedded SQL from Informix to MS SQL Server, more than 40 thousand lines of code in Visual Basic to C#, and over 80 thousand lines of code in ASP to ASP.NET.

Results & Advantages

Migration of the complex system (ASP site with PowerBuilder and Visual Basic component) was completed within a short span of time. In spite of the intricacies involved with migration of database access layer for PowerBuilder components, our technical specialists faced no issues during the migration process. For higher efficiency, correction of complex joins and dynamic queries were incorporated to the project during the testing period.

2014



Learn more about Informix to Microsoft SQL Server Migration

 
PgConf.Russia 2017
March 3, 2017 PgConf.Russia 2017

We are happy to announce that Ispirer Systems will take part in the International Conference PGConf.Russia 2017 that will be held on March 15-17, 2017 in Moscow.


Testimonials
February 27, 2017Digital Vantage Point, Canada
MS SQL Server to MySQL

"I suspect that Ispirer is often used by customers looking for a solution to help them port a lot of data from one database type to another. The process may require...

...

January 26, 2017Susquehanna Information Systems, United States
IBM DB2 AS/400 to Microsoft SQL Server

"To Whom it May Concern:

Susquehanna Information Systems is committed to mid-sized companies. Our goal is to offer our customers the best available...

...

Feedback

I must say that your tool is perfect, I used it only twice, once to test and the second time to do the final work. In less than two minutes I found the exact MSSQL database. If I would find myself again in a similar situation I would not hesitate to consider your other products.

Read more
Company News
Industry Events