Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem converting captured SQL Server 2000 database to Oracle

Liam67Jun 7 2010 — edited Jun 8 2010

Java(TM) Platform 1.6.0_17
Oracle IDE 2.1.1.64.45
Versioning Support 2.1.1.64.45

After creating MWREP user, granting it privileges and creating the migration repository, I have captured a small SQL Server 2000 database (1 table), but after performing "Convert to Oracle", I get the message that it has transformed correctly, but no converted model is shown. I was originally using the JRE supplied with SQL Developer 2.1.1, but replaced that with 1.6 U17 after researching the problem here.

The only message in the Migration Log is as follows:
Catalog RAC, Schema dbo coalesced to single schema dbo_RAC

The following message appears in the console:
SELECT DISTINCT(REF_ID_FK), REF_TYPE FROM MD_ADDITIONAL_PROPERTIES WHERE PROP_KEY IN (?) AND CONNECTION_ID_FK = ?

I have tried this with a more complex database, with no luck.

Any thoughts?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2010

Added on Jun 7 2010

#database-and-application-migrations, #sqldeveloper

4 comments

1,429 views