OraFAQ Forum: Server Utilities » importing sql server database

Home » RDBMS Server » Server Utilities » importing sql server database

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

importing sql server database [message #241191]

Mon, 28 May 2007 13:47

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

i have a database in sql server2000 and i want to import it oracle 10g
and i do not know how to do that

Report message to a moderator

Re: importing sql server database [message #241194 is a reply to message #241191]

Mon, 28 May 2007 14:23

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

Senior Member
Account Moderator

You can:
- unload your data in csv file and use sql*loader to load them in Oracle
- use Oracle Heterogeneous Service
- use an ODBC compatible program (for instance Excel or write one)

Regards
Michel

Report message to a moderator

Re: importing sql server database [message #241266 is a reply to message #241194]

Tue, 29 May 2007 01:03

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

You may also want download Oracle's SQL Developer Migration Workbench - to see what it can do. For more info see http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html

Report message to a moderator

Re: importing sql server database [message #242123 is a reply to message #241266]

Thu, 31 May 2007 13:26

adee_saleh
Messages: 30
Registered: May 2007
Location: Yemen

Member

thanks a lot for your support i get it and i really appreciate your support

Adee

Report message to a moderator

Previous Topic:	8i nested table export, not importing into 10g
Next Topic:	export error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 16:59:44 CST 2025