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: www.swissql.com

24/7 Product Support: support@swissql.com

Sales Queries: sales@adventnet.com

Free Edition Download : http://www.swissql.com/download.html