SQL Developer 2.1 - Associate Migration Repository errors
Hi, I want to migrate a SQL Server 2008 database to Oracle 10.2.0.3. I created the MWREP user in the Oracle 10.2.0.3 db per the migration demo. When I try to Associate Migration Repository (right click active connection) get error message "SQL Error on Script Execution. Try deleting the repository before Creating Repository.". No details appear in the message log as to what the error is. I setup a logon trace but the trace file does not have any errors that I can see. I have retried several times and get the same error. Any help is greatly appreciated! Thanks, Tom
SQL Server 2008 is not yet supported, use a previous one... Have fun, K.
Hi K, Thanks for the info. I also tried with a SQL 2005 database but still get the same error associating the migration repository. Since associating the migration repository is only creating a repositry in an oracle instance it doesn't appear to relate to the version of SQL Server. Regards, Tom
Right :) sorry. I'd say you're missing privileges then. Can you grant that user e.g. DBA to test? K.
Thanks for the suggestion K. I gave the user DBA and sysdba but still get the same error :( Regards, Tom
Hi, Having same problem. Trying to migrate SQL Server 2005 database and on association is gives same error. User has full rights on ORACLE database.
Hi, I found the solution for this. When i had created the connection i had set the role as SYSDBA. So what i did is modify the connection to use the role Default rather than SYSDBA and the system created me the repository without errors. Regards Hamish Schembri
Read only user access
Explain Plan and Autotrace Not Working in 2.1 EA2?
Too Many Tables? Can I Display A Subset?
2.1 EA2: Date columns displayed wrong in Grid
Using REF with object table in SQL Developer
Custom Reports in SQL Developer and translations files
Inserting in VIEW does not work in GUI
EA2 - invalid option for ALTER SESSION when logging in to 9i DB via EA2
Issue regarding display
Sql developer 2.1 error messages
SQL Developer and instantClient in iMac
Source does not have a runnable target
SQL Developer 2.1 EA2 does not show any procedures
SQL Developer 2.1 EA2 and Version Control issue
SQL Developer 2.1 EA2 issue with TNS connections