|
This month's 2 click survey: Is .NET important for a database professional? |
|
Click here to find out the top 15 SQL Server books purchased by this site's visitors! NEW |
| Want to keep in touch with the latest in SQL Server world? Email vyaskn@hotmail.com with 'subscribe' in the subject line |
|
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 on Microsoft 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. 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:
|
|||||||||||||||||||