Home » RDBMS Server » Server Administration » For Transferring data Sql server to Oracle 8i server
For Transferring data Sql server to Oracle 8i server [message #53593] Tue, 01 October 2002 02:12 Go to next message
vinit
Messages: 7
Registered: October 1999
Junior Member
I have so many procedure and triggers written and stored in Sql server, is there any techinque
Re: For Transferring data Sql server to Oracle 8i server [message #53596 is a reply to message #53593] Tue, 01 October 2002 03:39 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Have a look at the tool Oracle Migration Workbench
http://otn.oracle.com/tech/migration/workbench/content.html

HTH
Mike
Re: For Transferring data Sql server to Oracle 8i server [message #53633 is a reply to message #53593] Wed, 02 October 2002 10:58 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hi ,
I am currently working on the same job (i.e.) Migration.
Yes , i used OMWB (Migration Work bench) it was successfull in getting Tables, Data, Triggers (Be carefull with Text Datatypes convert them to Varchar2 rather than to LOBS, Triggers, Identities etc) but coming to Stored procedures, I am re-writing them though OMWB will convert them too, as there will be hell out of Jeopardy in the code generated.. I did heavy research and ultimately decided to re-write them....

sai
Previous Topic: ORA-00313 ,ORA-00312
Next Topic: oracle 9i - to large
Goto Forum:
  


Current Time: Fri Dec 27 00:49:24 CST 2024