Using SSMA Tester Option

Question

 Hi all

I have used SSMA utility to migrate data from Oracle to SQL 2005 , and i am using SSMA Tester option to test whether the data which got migrated is of correct format.
I have done the following

a) created test case

b) selected the required database. I want only tables to be checked, so i have unchecked all other options apart from table

c) selected only one table from tables folder

d) Click next , till finish. And clicked Run and i am getting the following message

"the version of the tester extension schema in the oracle db is unknown
do you want to reinstall the extensions?"

e) In SSMA i am able to see the corresponding error as


"error : Failed to load Tester database major version from the Oracle server.
Version of installed data is unknown.
Error occurred during following command execution:
CREATE USER ssmatester_oracle IDENTIFIED BY TESTER
Tester database reinstallation failed."


============================================================

i am not understanding how to proceed with this error.Please suggest.

---

sainath !analyze

Answer 1

You need to connect to SSMA (use button on top "connect to oracle") as SYSTEM user and try to run test case (DONOT create user ssmatester2008 on oracle).

Answer 2

Hi sainath,


Were you ever able to get your tester in SSMA to work? I have the same issue as you. We have create user rights assigned too.