A US Federal Agency resolved to convert their Legacy Mainframe Financial Systems to a distributed platform with a .Net/MVC architecture using SQL Server databases. The Agency required that the entire conversion effort be performed in a strictly “like to like” manner, with no modifications in the business logic of the programs or the data structures. The modernized system and databases must match the legacy system exactly. Dumas Software was responsible for all data conversion to SQL Server.
The scope of the job was enormous and required the most efficient processes available, due to the volume of legacy data. Some legacy databases contained hundreds of millions of rows and the tables had to be converted exactly “as is” with no changes or subsets allowed for efficiency or processing time.
The deliverable for Dumas Software was a set of re-runnable jobs that the client could execute independently on site for Production Go Live.
Dumas Created SQL Server databases and tables for hundreds of legacy and mainframe data sources. Dumas designed a combination of encrypted SQL Server Integration Services (SSIS) packages with C# script components, SQL jobs, and stored procedures, to migrate data to each SQL Server target database.
Dumas also performed data validation source and target SQL Server databases using a separate set of encrypted SSIS packages with C# script components, SQL jobs, and stored procedures.
The legacy data conversion was executed with 100% success and accuracy. Not a single problem was encountered.