Wednesday, May 9, 2012

Blog for Oracle to MS SQL DBA Migration Methods

Oracle TO SQL Server DBA Migration






SQL Server Connection from Oracle SQL Developer

Connection from SQL Developer to MS SQL.
1.Download jtds-1.2.5-dist
2.Extract Files
3.Go to SQL Developer's TOOL Menu-->Preferences-->Search like Third Party JDBC



4.Click Add Entry -->Add jtds-1.2.5.jar File.
5.Search file ntlmauth.dll into @@jtds-1.2.5-dist\x86\SSO\
and  put into @@\Java\jre1.6.0_12\bin
6.Restart SQL Developer.
7.Go to New Connection and Tab of SQL Server.


8.Give username,password,hostname(instance name),TCP/IP Port.

Eg.


10.Test and Check Status as Success.