OraFAQ Forum: Client Tools » How can i convert database from SQL server to Oracle?

Home » Other » Client Tools » How can i convert database from SQL server to Oracle?

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

How can i convert database from SQL server to Oracle? [message #288110]

Fri, 14 December 2007 21:59

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

HI,
friend i am facing one problem to transfer all database from SQL server to Oracle so can u suggest or send me some tool with help of it i can do it.? as i have used the product swis Sql but does not get any good result.

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288113 is a reply to message #288110]

Fri, 14 December 2007 22:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines as stated in URL above.

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288136 is a reply to message #288110]

Sat, 15 December 2007 00:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

convert just the code or database?
Did you look into Oracle migration workbench?

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288141 is a reply to message #288110]

Sat, 15 December 2007 01:12

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The hard part is not to load a SQL Server database into an Oracle database, it is to rewrite your applications for Oracle.
Transaction, concurrency, locking mechanism and so on are different in the two RDBMS and so they have to be used differently.

Regards
Michel

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288150 is a reply to message #288136]

Sat, 15 December 2007 02:31

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

hi can u tell me where i can get this Oracle migration?

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288152 is a reply to message #288141]

Sat, 15 December 2007 02:34

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

yes i am total agree with you so can u suggest me how can i do the conversion as my database is in SQL Server 2000 and now my requirement is to Convert whole database into Oracle 9i. Can u suggest me any free software or any query to do my job.

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288159 is a reply to message #288150]

Sat, 15 December 2007 03:24

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

hi can u tell me where i can get this Oracle migration?

1/ don't use IM speak
2/ did you try http://www.oracle.com ?

Regards
Michel

Report message to a moderator

Re: How can i convert database from SQL server to Oracle? [message #288170 is a reply to message #288152]

Sat, 15 December 2007 05:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is been already suggested.
Did you atleast google for Oracle Migration Workbench?

Report message to a moderator

Previous Topic:	developer sql
Next Topic:	How i can Run a Procedure only from API

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 00:24:58 CST 2025