Home » Open Source » MySQL » how to import oracle database in mysql database
how to import oracle database in mysql database [message #137051] Tue, 13 September 2005 00:31 Go to next message
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
Member
hi
i have exported users from oracle database ,

the content (tables present in that users) should be imported to mysql database .

what is procedure to exp oracle tables to mysql database.


Ravikumar.V

Report message to a moderator

Re: how to import oracle database in mysql database [message #137115 is a reply to message #137051] Tue, 13 September 2005 06:10 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member



http://www.google.co.in/search?hl=en&q=move+Oracle+database+to+Mysql&btnG=Search&meta=

Report message to a moderator

Re: how to import oracle database in mysql database [message #137686 is a reply to message #137051] Fri, 16 September 2005 02:18 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
The best tools to migrate tables definitions is "MySQL Migration Toolkit". You can get it at here http://www.mysql.com/products/tools/migration-toolkit/
You also can use it for migrating data.

If there are millions of rows, I suggest that you'd better dump oracle data into text files, column values seperate by 'Tab'. Then using mysql tool "mysqlimport" to import the data.

Hope this helpful.

Alexzeng

Report message to a moderator

Previous Topic: Oracle9i replication to MYSQL 5.0
Next Topic: MySQL and Oracle SQL- the same function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Mar 26 14:04:49 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.