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
|
| 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 |
|
|
|
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 timein 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/freedownload.html
|
