RE: Sql Developer - Migration from Sql Server to Oracle Database
- From: "Sam Bootsma" <sbootsma@xxxxxxxxxxxxxx>
- To: "Turloch O'Tierney" <turloch@xxxxxxxxx>
- Date: Fri, 25 Jul 2008 09:34:13 -0400
Turloch's suggestion worked for me.
This is what I put in for the various fields:
Userid: sa
Password:
Hostname: <servername>
Port: <portnumber>/<databasename>;instance=<instancename>
When I clicked the connect button, it connected me. Thanks Turloch!
Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx
-----Original Message-----
From: Turloch O'Tierney [mailto:turloch@xxxxxxxxx]
Sent: July 23, 2008 5:36 AM
To: Sam Bootsma
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Sql Developer - Migration from Sql Server to Oracle
Database
On Wed, Jul 16, 2008 at 10:16 PM, Sam Bootsma <sbootsma@xxxxxxxxxxxxxx>
wrote:
>
> 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.
>
> ...
>
> 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.
>
>
I am from Oracle SQLDeveloper (Migration) development, Sam confirmed
the following workaround for connecting to the non default instance
of SQLServer on the same port.
Please contact us via the SQLDeveloper forum [not sure if I am allowed
to give links here] .
Workaround supplied by another customer:
This took some figuring out but I cracked it in the end....
SQLServer tab:
Hostname: <servername>
Port: <portnumber>/<databasename>;instance=<instancename>
so for me the Port field looks like this: 1433/Gaffa;instance=SQL01
That should now connect to a named instance SQL Server.
Paul Fairhurst
Regards,
Turloch
--
//www.freelists.org/webpage/oracle-l
Other related posts:
