SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SwisSQL Helps Major ERP Vendor in Database Migration of Oracle to SQL

By Susan Suganthi,

Case Study Snapshot

The Subject of the case study is a global provider of personalized enterprise solutions with a turnover close to USD 300 million. It employs over 7000 people and has over 1,000 customers across 30 countries. The ERP vendor wanted to migrate 2.5 million lines of code in ERP Aviation module from Oracle to Microsoft SQL Server. The ERP vendor looked out for an automated, reliable, and affordable Stored procedure migration solution.

[The name of the ERP vendor has not been revealed on request considering the competitive environment prevailing in that segment]

SwisSQL Solution

SwisSQL offered automated database migration up to 90%, saving cost by 80%. It offered productive, predictable and controlled migration environment at affordable price.

SwisSQL Benefits

. Simple and reliable Migration, ensures application and data Integrity.
. Cuts cost and time drastically, automated migration for up to 90% of manual tasks.
. Moves rapidly to deployment

Manual Migration
Lines of code 2.5 million
Team size 10
Total Duration 6 months
Person months 60
Cost $240.000*
* - calculated at $4K per person per mon
SwisSQL Helps Major ERP Vendor in Database Migration from Oracle to SQL Server

A Major ERP Vendor saved an estimated $200K and 52 person months using SwisSQL to migrate 2.5 million lines of mission critical module from Oracle to Microsoft SQL Server.

Business Challenge

The ERP vendor, a global provider of customized enterprise solutions developed Aircraft maintenance solutions. Its Enterprise Asset Management for aviation, consists of modules covering all areas of enterprise management for the fixed wing aircraft and helicopter maintenance industry. The solution is implemented on client server and web transactions platform with e-business and mobile computing capabilities.

Most of the ERP vendor's applications were based MS SQL Server, a few modules were built on Oracle.The Aircraft Maintenance solution had a critical module with close to 2.5 million lines of Oracle PL/SQL code and their business logic was implemented in Oracle PL/SQL. The ERP vendor wanted to migrate the entire application and business logic to MS SQL Server Transact-SQL.  It was important that ERP application also utilizes MS SQL Server, in order to leverage its performance, scalability and cost advantage.

Earlier Lessons

The ERP vendor had an earlier experience of migrating one of the Aviation modules from Oracle to MS SQL Server manually with a 10 member team. The manual migration project did not materialize due to:

High Time and Resource Expenditures:

Manual migration required DB experts/Developers to analyze and understand the overall design and to manually re-structure all stored procedures. This method was tedious and error-prone.

Extensive Unpredictable Bugs:

Migrated procedures required compilation and validation before deploying them to MS SQL Server. With developer's individual programming logic, mistakes and bugs were prevalent, with unpredictable error patterns.

Lack of Automated Migration Tool:

With unpredictable bugs, issues, and high cost made the ERP vendor realize the need for a fast, dependable and cost effective automated migration solution.

SwisSQL Solution

SwisSQL offered the ERP vendor a quick turnaround solution to migrate and adapt to MS SQL Server and leverage its advantages instantly. Using SwisSQL - Oracle to SQL Server Database Migration Solution , the automated migration was quickly done.

Project Execution:

SwisSQL's standards-based efficient database migration reduced the ERP vendors validation and integration efforts through well-designed and automated tool. With SwisSQL's purposeful design, the ERP vendor was able to execute an efficient and successful database migration project well ahead of deadline by following steps:

    a. No pre-conditioning:

SwisSQL assisted the ERP vendor load stored procedures from local files or fetch from a live Oracle database and migrate it to MS SQL Server directly. Once the migration was complete, review and validation of the code was conducted for accuracy. This step required a small team and no heavy-handed DB expertise.

    b. Deployment and Validation:

The ERP vendor utilized SwisSQL to compile the migrated Transact SQL procedures in MS SQL Server. The compiled procedures were first unit tested and validated from within the business application environment. This process ensured accuracy and savings of time and resources.

    c. Reduced Integration Effort:

Integration of the migrated code with live business environment is a critical component of Database migration. SwisSQL's effective and standards based migration reduced validation and integration efforts by more than 50%.

Technical Benefits:

The ERP vendor leveraged SwisSQL's automated migration solution, which offered simple and reliable stored procedure migration, doing away with 90% of manual tasks that provided some obvious benefits including:

    a. Productivity Gains:

SwisSQL's automated migration tool helped the ERP vendor's migration team to focus just on analysis, review, corrections and performance tweaking of converted code offering efficient and productive migration.

    b. Controlled Validation and Deployment:

Enterprises understand that validation, testing, and integration phases are critical components of a database migration project. The ERP vendor saved close to 50% of cost and time in validation due to SwisSQL standards based migration, with minimal conversion errors, which were much easy to solve due to the predictable pattern of bugs and issues

    c. Complete Solution:

The ERP vendor was ahead of schedule, as they leveraged SwisSQL's complete solution, in migrating, testing, validating, and integrating. SwisSQL's direct support from technical developers helped the ERP vendor resolve the issues instantly.

Business Benefits:

Although the business justification to migrate to MS SQL Server existed, past experience however did not converge into real benefits. With SwisSQL, the ERP vendor recognized the impacts on business immediately. Some of the benefits to highlight are:

    a. Complete Ownership Control:

SwisSQL automated 90% of the code produced , thereby saving 80% of the investment that was spent on manual intervention. This made the ERP Vendor to have complete control over the migration.

    b. Faster Time to market:

Significant amount of time was lost during manual migration exercise and the ERP vendor was sensitive to the time factor. SwisSQL assisted the ERP vendor to rapidly reach its goals through its automated and reliable migration. This short migration cycle enabled the ERP vendor to capitalize on market opportunities faster.

    c. Immediate Time and Cost Savings:

Utilizing SwisSQL, the ERP vendor saved about $200K and 52 person months of investment and ensured faster time to production. The savings are from conversion and basic testing, and does not include the savings on validation and deployment.


Product website:
24/7 Product Support: support@swissql.com
Sales Queries: sales@adventnet.com
Free Edition Download : http://www.swissql.com/download.html


Total article views: 3070 | Views in the last 30 days: 1
Related Articles

DR solution

SAN/SQL server DR solution








Server Migration - Replication setup

Server Migration - Replication setup



There are multiple scripting solutions for migrating reports and roles from one server to another, h...

case studies    
white papers