OraFAQ Forum: Server Utilities » Moving data from MS Sql Server to Oracle

Home » RDBMS Server » Server Utilities » Moving data from MS Sql Server to Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving data from MS Sql Server to Oracle [message #71370]

Wed, 23 October 2002 08:27

Eddy Confer
Messages: 17
Registered: January 2002

Junior Member

What is the best way to move lots of data from a Microsoft Sql Server or Sybase database to Oracle?

Report message to a moderator

Re: Moving data from MS Sql Server to Oracle [message #71371 is a reply to message #71370]

Wed, 23 October 2002 12:59

Dinesh.T.K.
Messages: 1
Registered: October 2002

Junior Member

Eddy,

To export data from MS SQL Server to Oracle, you can use Data Transformation Services(DTS) - an export-import facility available in MS SQL Server.

Dinesh.

Report message to a moderator

Re: Moving data from MS Sql Server to Oracle [message #71381 is a reply to message #71370]

Thu, 24 October 2002 12:34

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi,
I have Just completed my job of Migrating 5GB of database from SQL Server 7 to ORacle 8.1.7 ..Believe me i tried all the options and ended up in using ORACLE Migration workbench for Tables migration and Manual Stored procedures Coonversion..
Do let me know if u were hooked at any point..

Sai

Report message to a moderator