Affordable Access

Automation of QA in the project of DB migration from SQL Server into Oracle

Authors
Publisher
Федеральное государственное бюджетное учреждение науки Институт системного программирования Российской академии наук
Publication Date
Keywords
  • Database
  • Data Migration
  • Testing
  • Reengineering
  • Quality Assurance

Abstract

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.

There are no comments yet on this publication. Be the first to share your thoughts.