I am trying to migrate a sample database from mysql to Oracle 11g using an SQL developer. I am browsing an online tutorial and doing all the steps, but I don't know why there is no data in the target database.
Here is what I did:
Connect to MySQL (connection name "MySQL") using SQL Developer with JConnector, log in as root.
Create an empty repository schema during migration named "TEMPBUFFER"
Create a target schema for storing data in Oracle called "DEVELOPER"
Follow the migration wizard:
Migration repository = TEMPBUFFER Third-
party database for migration = MySQL
Target scheme in Oracle = DEVELOPER
Only one database called "classmodels" is selected for immigration from MySQL
So here are my questions:
On top of that, why is there no table / data on the DEVELOPER schema, how to fix it?
What is a migration repository and why do we need it? There seem to be some tables with configuration information, so very often we have to use the target schema as a migration repository?
Thanks in advance.
source
share