This discussion is archived
1 Reply Latest reply: Apr 19, 2013 2:16 AM by mkirtley-Oracle RSS

Migration Requirements - drivers etc?

1003849 Newbie
Currently Being Moderated
Hi

What software will I need to download to do a SQL server 2008 to oracle 11g express migration?

I have already downloaded SQL oracle developer and the Oracle Workbech. Will I need to download a driver to? Where can I find the latest?
I am using Windows 2008 server.

Thanks

Jan
  • 1. Re: Migration Requirements - drivers etc?
    mkirtley-Oracle Expert
    Currently Being Moderated
    Jan,
    To make the connection from SQL*Developer to the SQL*Server database you will need to download a third party JDBC driver.
    This is described in the documentation available from here -

    http://docs.oracle.com/cd/E35137_01/index.htm

    Oracle® SQL Developer
    User's Guide Release 3.2

    In the section -

    Database: Third Party JDBC Drivers

    Database: Third Party JDBC Drivers
    The Third Party JDBC Drivers pane specifies drivers to be used for connections to third-party (non-Oracle) databases, such as IBM DB2, MySQL, Microsoft SQL Server, or Sybase Adaptive Server. (You do not need to add a driver for connections to Microsoft Access databases.) To add a driver, click Add Entry and select the path for the driver:
    ■For IBM DB2: the db2jcc.jar and db2jcc_license_cu.jar files, which are available from IBM
    ■For MySQL: a file with a name similar to mysql-connector-java-5.0.4-bin.jar, in a directory under the one into which you unzipped the download for the MySQL driver
    ■For Microsoft SQL Server or Sybase Adaptive Server: jtds-1.2.jar, which is included in the jtds-1.2-dist.zip download
    ■For Teradata: tdgssconfig.jar and terajdbc4.jar, which are included (along with a readme.txt file) in the TeraJDBC__indep_indep.12.00.00.110.zip or TeraJDBC__indep_indep.12.00.00.110.tar download

    Alternative:
    As an alternative to using this preference, you can click Help, then Check for Updates to install the JTDS JDBC Driver for Microsoft SQL Server and the MySQL JDBE Driver as extensions.

    To find a specific third-party JDBC driver, see the appropriate website (for example, http://www.mysql.com for the MySQL Connector/J JDBC driver for MySQL, http://jtds.sourceforge.net/ for the jTDS driver for Microsoft SQL Server and Sybase Adaptive Server, or search at http://www.teradata.com/ for the JDBC driver for Teradata). For MySQL, use the MySQL 5.0 driver, not 5.1 or later, with SQL Developer release 1.5.
    You must specify a third-party JDBC driver or install a driver using the Check for Updates feature before you can create a database connection to a third-party database of that associated type. (See the tabs for creating connections to third-party databases in the Create/Edit/Select Database Connection dialog box.)

    Regards,
    Mike

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points