MySQL Database Migrate to Oracle 11g

SQL Server to Oracle Database Migration using SQL Developer

1. Create a Connection with SQL Server.

 Right Click on created connection with sql server.

2.












3.

4.

 5.


.

6

7.

8.

9.

10.

11.

12. 

13.

How to connect MYSQL database to SQL Developer

1.Down load the JDBC driver from given site.

http://dev.mysql.com/downloads/connector/j/5.0.html


2. Go to Tools menu and select the Preferences.

3. Select the driver which downloaded.

4.

5.

How can i connect SQL Server in SQL Developer

I'm using SQL Developer, I want to connect SQL Server n it and migrate data from SQL Server to Oracle 11g. When click on Retrieve Databaser its give me the following error:-



"Status: Failur-I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property."


Solution:


1 - Download and open the JTDS folder.
2 - The ntlmauth.dll you will find inside the x86/SSO folder
3 - The JtdsXA.dll you will find inside the x86/XA folder
4 - Put the ntlmauth.ddl and JtdsXA.dll inside de Sql Developer/sqldeveloper/bin
5 - Copy the jtds-1.2.4.jar to Sql Developer/sqldeveloper/lib