A global data-warehousing public company contacted Ispirer from their office located in Turkey. Besides of enterprise-level data storage service, the company offers sophisticated marketing solutions, analytics and consulting services. Their team can also help with marketing resource management. Moreover, this global leader employing more than 10,000 specialists provides education opportunities in technical and business fields. They contacted Ispirer in regard of migration task for one of their clients working in IT field.
The client had to stop using Microsoft SQL Server as their main RDBMS due to an internal reason. The sustainment database platform must keep pace with changing needs of this company. Teradata platform appeared to be a good alternative for their business needs.
Ispirer was called upon to address issues relating to migration from Microsoft SQL Server to Teradata of about 100 thousand lines of code containing in SQL objects.
The SQL could be effectively migrated to the target environment using the Ispirer Migration and Modernization Toolkit 2015. Experienced Ispirer Migration Experts performed analysis of the customer’s code. Some changes to the existing conversion rules were required to determine the best automatic conversion. Ispirer technical team prepared and tested the fit-for-purpose Toolkit by extending the cases of conversion for the following statements:
- WITH common_table_expression;
- TRY…CATCH construct;
- RAISERROR Statement;
- IDENTITY property;
- PRIMARY KEY constraint on multiple columns;
- Table-Valued User-Defined Functions;
- CREATE VIEW Statement WITH common_table_expression;
- SELECT INTO statement.
After the extensions the Toolkit was licensed to the customer. When the migration started, Ispirer consultants sustained the migration process by working alongside with the customer’s technicians. The Toolkit converted all the SQL objects in Teradata environment automatically.
Results and Advantages
Thanks to Ispirer the migration was completed in a short time. The client’s database continues to meet the needs of the business.