Home » RDBMS Server » Server Utilities » importing sql server database
importing sql server database [message #241191] Mon, 28 May 2007 13:47 Go to next message
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

Re: importing sql server database [message #241194 is a reply to message #241191] Mon, 28 May 2007 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: importing sql server database [message #241266 is a reply to message #241194] Tue, 29 May 2007 01:03 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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
Re: importing sql server database [message #242123 is a reply to message #241266] Thu, 31 May 2007 13:26 Go to previous message
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
Previous Topic: 8i nested table export, not importing into 10g
Next Topic: export error
Goto Forum:
  


Current Time: Mon Dec 05 21:20:34 CST 2016

Total time taken to generate the page: 0.12601 seconds