ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 异构数据库系统迁移到Oracle 工具 - Oracle SQL Developer

异构数据库系统迁移到Oracle 工具 - Oracle SQL Developer

原创 Linux操作系统 作者:tolywang 时间:2011-08-02 13:38:06 0 删除 编辑

1.     在Oracle 网站下载  sqldeveloper-3.0.04.34.zip 

2.     参考 http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html 

Once downloaded you need to expand the driver binary jar file to a location on your machine. The driver binary jar file is typically a separate jar file located inside the downloaded archive file. Once you have extracted the relevant jar file to your disk, you need to configure SQL Developer to tell it where this driver resides:

  1. In SQL Developer choose Tools -> Preferences...
  2. Expand the "Database" option in the left hand tree
  3. Click on "Third Party JDBC Drivers"
  4. Click on "Add Entry..."
  5. Navigate to your third-party driver jar file and choose OK

 

 

其他参考

. Copy to Oracle

Oracle SQL Developer 3.0 introduces a Copy to Oracle option that allows users to copy tables and data from a third-party database to Oracle without the need of a migration repository. This quick migrate option is very useful for quickly copying a few tables to Oracle and requires no additional setup. This feature is only available for copying tables and the data; use the Migration Wizard if you are migrating more than that.

To use Copy to Oracle, select the third-party connection created in 2. Adding a Third Party Connection above. This invokes a connection dialog that enables you to select the Oracle connection where you want to copy the table(s) and click Apply.

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-703809/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13472208