Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

I try to migrate a sample database from mysql to Oracle 11g using SQL developer. I go through some online tutorial and follow each steps but I don't know why there is no data show up in the target database.

Here is what I did:

  1. Connect to MySQL(connection name "MySQL") using SQL Developer with JConnector, log on as root.

  2. Create a empty schema for "Repository" during migration named "TEMPBUFFER"

  3. Create a target schema for holding the data in Oracle, named "DEVELOPER"

  4. Follow migration wizard:

Migration Repository = TEMPBUFFER
Third party database for migration = MySQL
Target schema in Oracle = DEVELOPER
Only one database called "classmodels" is chosen to be immigrated from MySQL

So here are my questions:

  1. On top of everything, why there is no table/data show up on DEVELOPER schema, how to fix it?

  2. What is a Migration Repository and why we need it? It seems hold a few tables with config information, so is it very common we should use the target schema as Migration Repository?

Thanks in advance.

share|improve this question

1 Answer

up vote 1 down vote

i know this is old but the last step is to do copy to oracle when right click the tables on the source scheme

step 27 in this tut http://taliphakanozturken.wordpress.com/tag/db-migration-using-sql-developer/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.