Testing Migrated Database Objects (OracleToSQL)
Microsoft SQL Server Migration Assistant for Oracle Tester (SSMA Tester) automatically tests the database object conversion and the data migration made by SSMA. After all SSMA migration steps are finished, use SSMA Tester to verify that converted objects work the same way and that all data was transferred properly.
You can test the following object types with SSMA Tester:
- Tables
- Stored procedures, including packaged procedures
- User-defined functions, including packaged functions
- Views
- Standalone statements
SSMA Tester executes objects selected for testing on Oracle and their counterparts in SQL Server. After that, it compares the results according to the following criteria:
- Are the changes in table data identical?
- Are the values of output parameters for procedures and functions identical?
- Do functions return the same results?
- Are the result sets identical?
Note
Attention! Never use SSMA Tester on production systems. During Tester execution the source schema and data are modified. The complete restoration of the original state may be impossible for some types of tested code.
Prerequisites
In order to enable comparison of the resulting table data, set the Generate ROWID column option to Yes before the schema conversion starts. SSMA will add a ROWID column to all tables during execution of the Convert Schema command.
Note that the current version of SSMA Tester does not support parallel execution by different users on the same source or target server.
Getting Started
Creating Test Cases (OracleToSQL)