Sql Developer - Migration from Sql Server to Oracle Database

From: Sam Bootsma <sbootsma_at_georgebrown.ca>
Date: Wed, 16 Jul 2008 17:16:25 -0400
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A105347E46@TCCEML02.gbrownc.on.ca>

I installed Oracle Sql Developer 1.5.1 today. I also installed a 3rd party JDBC driver
(C:\sqldeveloper\sqldeveloper\extensions\oracle.sqldeveloper.thirdparty. drivers.sqlserver\lib\jtds-1.2.jar) using Tools / Preferences / Database / 3rd party JDBC Drivers.  

When I go to create a new connection to our Sql Server database, I enter the username and password, select the Sql Server tab, enter the host name and leave the port as the default (1433). I know I also have to specify that the Sql Server instance is A02, but there is no place to enter this information. Instead, there is a button that says "retrieve database". I push the button, and it returns the message "Status: Failure - Login failed for user 'sa'."  

If I save the connection info and double-click the connection entry it tells me the same thing, but also adds that the vendor code is 18456.  

I am able to connect to this database using Sql Server Management Express, so I know that the user id / password combination I am using is correct. Can anybody shed some light on this? My ultimate goal is to migrate Sql Server data to the Oracle database. The vendor says there is no code in the Sql Server database - just data in tables.  


Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>  

Received on Wed Jul 16 2008 - 16:16:25 CDT

Original text of this message