Oracle SQL Developer configured for Microsoft SQL Server

Oracle SQL Developer configured for Microsoft SQL Server

1. Download the SQL Developer from Oracle Web Site.
Note: Create account on Oracle Site and download it.

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

2. Download the plugin for Configured the Microsoft SQL Server into the SQL Developer.

http://www.oracle.com/technetwork/database/migration/jdbc-migration-1923524.html

Choose for sql server driver and download it (JTDS driver version Download)

Direct link: https://sourceforge.net/projects/jtds/files/jtds/1.3.1
Download : jtds-1.3.1-dist.zip

3. Unzip the SQL developer folder and open the sqldeveloper.exe file on windows platform:

sqldeveloper.exe

Sql developer.JPG

4. Sql Server is open and add new connection from right side + sign button:

AddConnection.JPG

 

5. Now you will see only option for Oracle and Access database for connectivity.

 

Addconnection3.JPG

6. Now cancel this window, go to Tool –> Preferences, A new window will open.

Expand the database —> go to third party JDBC Driver –> Add the downloaded driver

Note: Extract the download JTDS software and add file upto jar file in below entry.

JDBCDriverJPG

7. Now you open again the connection add button on right side. It will show you the connection for sql Server and Sysbase database

ConnectionSQLServer

Advertisements

One thought on “Oracle SQL Developer configured for Microsoft SQL Server

  1. Pingback: Migrate database from MS SQL Server to Oracle | Smart way of Technology

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s