異構資料庫系統遷移到Oracle 工具 - Oracle SQL Developer

1.     在Oracle 網站下載  sqldeveloper-3.0.04.34.zip 

2.     參考  

• IBM DB2: You need the binary driver jar files db2jcc.jar and db2jcc_license_cu.jar. Search for DB2 Universal JDBC Drivers or follow the links from
• Microsoft Access: No additional driver is required. Access uses the JDBC/ODBC bridge
• Microsoft SQL Server and Sybase: jTDS driver available from . Use version 1.2 (Download available from )
  When you download the jtds distribution, you download an archive file called jtds-1.2-dist.zip. The binary driver jar file is located within this file is called jtds-1.2.jar
• MySQL: MySQL JDBC Driver, version 5.04 available from http://dev.mysql.com/downloads/connector/j/5.0.html
  You download an archive file called mysql-connector-java-5.0.4.tar.gz (or .zip). Inside this file, the binary driver jar file is called mysql-connector-java-5.0.4-bin.jar
  
• Teradata:The Teradata driver is available from You need to download Teradata JDBC Driver 12.0 or above. Both the Teradata JDBC Driver 12.0 and 13.0 use the jar files terajdbc4.jar and tdgssconfig.jar

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. 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.