SW development for data migration security for a web domain administrating company

SW development of proof applications documenting the completeness, equality and data integrity of migrated date for a web-domain administrating company.

 

Project tasks:

  • Implementation of Transact SQL scripts for migration analysis

  • Execution of equivalency tests of the data models

  • Representation of the results of these tests in Excel tables.

  • Automatization of test procedures by making use of Stored Procedures

  • Usage of the Sybase Adaptive Server Enterprise 15 with database tools Sybase Central and Interactive SQL, and of Windows XP isql for command line changes

  • Creation of a QS concept for storing the results of the SQL queries in new database tables.

 

Project environment:

  • Sybase Adaptive Server Enterprise 15

  • Sybase Central

  • Interactive SQL 9 (Tool) / Transact SQL

  • ISQL (over Windows XP)

  • Microsoft Office 2003 (Word, Excel)