使用 SQL Developer 3 将 MySQL 数据库迁移到 Oracle 11g
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10624914/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Migrate MySQL database to Oracle 11g with SQL Developer 3
提问by Dreamer
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.
我尝试使用 SQL 开发人员将示例数据库从 mysql 迁移到 Oracle 11g。我浏览了一些在线教程并按照每个步骤进行操作，但我不知道为什么目标数据库中没有显示数据。
Here is what I did:
这是我所做的：
Connect to MySQL(connection name "MySQL") using SQL Developer with JConnector, log on as root.
Create a empty schema for "Repository" during migration named "TEMPBUFFER"
Create a target schema for holding the data in Oracle, named "DEVELOPER"
Follow migration wizard:
使用带有 JConnector 的 SQL Developer 连接到 MySQL（连接名称“MySQL”），以 root 身份登录。
在迁移过程中为“存储库”创建一个名为“TEMPBUFFER”的空架构
创建一个用于在 Oracle 中保存数据的目标模式，名为“DEVELOPER”
遵循迁移向导：
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
Migration Repository = TEMPBUFFER
用于迁移的第三方数据库 = MySQL
Oracle 中的目标模式 = DEVELOPER
仅选择一个名为“classmodel”的数据库从 MySQL 迁移
So here are my questions:
所以这里是我的问题：
On top of everything, why there is no table/data show up on DEVELOPER schema, how to fix it?
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?
最重要的是，为什么 DEVELOPER 架构上没有显示表/数据，如何解决？
什么是迁移存储库，为什么我们需要它？似乎有一些带有配置信息的表，所以我们应该使用目标模式作为迁移存储库是很常见的吗？
Thanks in advance.
提前致谢。
回答by Ahmed D. Sherif
i know this is old but the last step is to do copy to oracle when right click the tables on the source scheme
我知道这是旧的，但最后一步是在源方案上右键单击表时复制到 oracle
step 27 in this tut http://taliphakanozturken.wordpress.com/tag/db-migration-using-sql-developer/
此 tut 中的第 27 步 http://taliphakanozturken.wordpress.com/tag/db-migration-using-sql-developer/
