Automation of QA in the Project of DB Migration from SQL Server into Oracle

This paper describes an automatic QA organization experience in the industrial project of DB migration from MS SQL Server 2005 to Oracle 11gR2. The resulting DB of the project is supposed to contain the same data and to have a functional correspondence with the initial one. The initial DB is quite huge: 6 terabytes of data and 2500 KSLOC of stored procedures. The documentation for the initial base is incomplete and outdated and doesn’t correspond with the database in question. Functional specifications for stored procedures are missing, as well as tests. This article contains the description of the main problems solved during the project, solutions and an estimation of their applicability based on implementation experience.