Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
In SQL Server Migration Assistant for Oracle, when using SSMA Tester option to test the correctness of migrated data, you may see the following error message:
Installed data not found. Error occurred during following command execution:
CREATE USER ssmatester oracle IDENTIFIED BY TESTER
Tester database installation failed
The SSMA Tester option requires that SSMATESTER_ORACLE schema is installed in the Oracle database. The error usually occurs due to a failure in execution of the following command because the user does not have sufficient privileges
CREATE USER ssmatester_oracle IDENTIFIED BY TESTER
Connect to the Oracle database using the same credentials that you are using in SSMA and manually add the ssmatester_oracle user by executing the following command using Oracle's tools:
CREATE USER ssmatester_oracle IDENTIFIED BY TESTER
Note: To create a new user and objects in the schema for that user you need to have necessary privileges on the Oracle server.
For more information on testing the correctness of migrated data, consult the following topic under SSMA Help
Keywords: vkball, kb