Home » Other » General » migrating sql server 2000 to oracle 9i
migrating sql server 2000 to oracle 9i [message #270379] Wed, 26 September 2007 13:00 Go to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I am trying to do some research on which utility is best to migrate sql server 2000 to oracle 9i. I am told that oracle migration workbench is best but I do not find an option from sqlserver to oracle. Can anyone suggest any other options? Thanks
Re: migrating sql server 2000 to oracle 9i [message #270398 is a reply to message #270379] Wed, 26 September 2007 14:59 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
The MS-SQL migration functionality is now available with Oracle's SQL Developer.
Re: migrating sql server 2000 to oracle 9i [message #270578 is a reply to message #270398] Thu, 27 September 2007 10:51 Go to previous message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Thanks for the response, Frank! I have installed sql developer and now I am unable to connect to the sql server.I need to create a new connection with SQL Developer Migration Workbench, to complete the migration but an error occured when i clicked on RETREIVE DATABASE :

Status: Failure -Network error IO Exception: Connection Refused: connect. I am loggin in using Windows Authentication and I have ensured that the TCP/IP is enabled in the SQL Server Network Configuration. Can you provide a solution? I have read the past thread and they do not provide one.
Previous Topic: Questions about free Oracle personal home version
Next Topic: help please
Goto Forum:
  


Current Time: Fri Apr 26 00:59:21 CDT 2024