Customer

Ispirer has already completed projects for customers from all seven continents, including South America. This time we had the honour to cooperate with a large software manufacturer based in Chile.

This company has an extensive experience in information and communications technologies (ICT). They offer comprehensive services that cover the full software development and maintenance, data and system migration and a full range of consulting services. The focus areas of consulting provided are software implementation and re-engineering of business processes.

Technologies

Sybase ASE, Microsoft SQL Server

Challenge

The Company took decision to migrate their legacy database to a modern and perspective platform. Microsoft SQL Server was chosen as the new database engine and expected to be easily integrated with other technologies.

The existing Sybase ASE database involved 1 thousand tables, 80 GB of data and around 3 thousand stored procedures. The overall volume of the legacy in Sybase ASE contained about 500 thousand lines of code.

“As our Company lacked resources for performing this migration task manually, we started researching ways to automate the process. “ – said the Chief Information Officer of the Company.

Solution

At first Ispirer analysts reviewed the specifications provided by the Client and analyzed the source database and the requirements to the target. This migration task could be indeed performed more efficiently using Ispirer MnMTK 2015. This required a short-term extension stage before the migration process. Ispirer Toolkit Developers expanded some of the existing functionalities of the Toolkit to ensure the best conversion result after the automatic migration.

The Software was fully tested to meet all the custom requirements and delivered to the Client. They acquired the Software Professional license for six months that included free technical support by Ispirer Migration Experts assigned to this project. Both data and SQL migration were carried out automatically at the Client’s premises.

Results & Advantages

The migration solution provided by Ispirer facilitated the Client’s migration task of moving Sybase ASE to Microsoft SQL Server. All the Client’s requirements were handled by Ispirer team with the help of Ispirer MnMTK 2015 within the promised timeline and cost estimate. As a result, our Client was able to obtain all the benefits of his modern RDBMS.

2015