Summary
- Customer: human capital management company
- Country: United States
- Product Used: Ispirer Toolkit license, Customization of Ispirer Toolkit
- Source technology: Oracle, SQL Server
- Target technology: PostgreSQL
- Project scope: 3500 tables, 365 000 LoC, 1 335 000 LoC
- Project duration: 1 year
Client profile
The customer is a world leader in contingent workforce management. Its industry-leading workforce management platform enables companies to optimize talent and diversity goals while achieving operational success. The platform offers software and services such as labor sourcing, payrolling, compliance, program management, and analytics.
Objective
The customer needed to efficiently modernize and migrate their databases within a tight timeframe, in order to avoid the disruption of business processes.
Challenge
The transition to PostgreSQL was based on a number of challenges our customer faced:
- A high total cost of ownership created a substantial financial burden, limiting the company’s ability to allocate resources to other critical areas.
- Vendor lock-in, which restricted their flexibility and hindered future business development.
Solution
Assessment stage
When migrating from Oracle and PostgreSQL, it is important to remember that PostgreSQL does not have all the necessary equivalents. Assessment Wizard provided a detailed report with an approximate migration assessment of 80% automation rate with default conversion. According to the report, customization of SQLWays Wizard would make it possible to achieve 95% automation. Therefore, we offered clients to customize SQLWays Wizard to minimize migration time.
Customization stage
The most important thing for our client was the migration time, which had to be minimized. For this purpose, Ispirer experts carried out seven customizations to achieve the maximum automation rate. This is what has been customized:
- Converting a table type to an array
- Adding a custom collation
- Removing an IF statement when it contains a DROP IF EXISTS statement
- Adding open swv_refcur for SELECT null
- Removing unnecessary INOUT refcursor parameters
- Converting an UPDATE with a JOIN statement
- Converting the format function
Technologies
SQL Server, Oracle, PostgreSQL
Benefits and Results
As a result of interaction with Ispirer, the cvustomer received the following results:
- Reduced total cost of ownership because of moving from proprietary Oracle and SQL Server to open-source PostgreSQL
- Migrate the databases at a 95% automation rate
- Streamlined migration project twice compared to manual migration
