OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Database backup

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

Database backup [message #405622]

Thu, 28 May 2009 12:44

kuldip
Messages: 10
Registered: November 2007

Junior Member

Hi All,
Could anyone of U guide me on How to take backup from mysql db to Oracle 11g database ?

Thanks in advance

Report message to a moderator

Re: Database backup [message #405625 is a reply to message #405622]

Thu, 28 May 2009 12:47

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

Senior Member
Account Moderator

What does this mean?

Regards
Michel

Report message to a moderator

Re: Database backup [message #405630 is a reply to message #405625]

Thu, 28 May 2009 12:58

kuldip
Messages: 10
Registered: November 2007

Junior Member

Thanks for your response.

We were using mysql as database in one of our older version of product.
Now we are going to use deploy its newer version.
And in this version Oracle 11g will be used. So we dont want to loose our stuffs.
So my question is without loosing any data, How we can backup the data from mysql to Oracle 11g ?

Thanks

Report message to a moderator

Re: Database backup [message #405631 is a reply to message #405625]

Thu, 28 May 2009 13:00

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>How we can backup the data from mysql to Oracle 11g ?

Smile

You need to migrade MySQL to Oracle; Check MySQL White Papers..

Babu

Report message to a moderator

Re: Database backup [message #405632 is a reply to message #405630]

Thu, 28 May 2009 13:02

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

Senior Member
Account Moderator

Look for Oracle Migration WorkBench.

Report message to a moderator

Re: Database backup [message #405633 is a reply to message #405630]

Thu, 28 May 2009 13:06

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

Senior Member
Account Moderator

Save your data in csv files and load them using SQL*Loader.

Or use ODBC to move the data from one database to the other one.

You can also use SQL Developer, read SQL Developer Supplementary Information for MySQL Migrations

Regards
Michel

[Updated on: Thu, 28 May 2009 13:06]

Report message to a moderator

Re: Database backup [message #405634 is a reply to message #405632]

Thu, 28 May 2009 13:07

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

Senior Member
Account Moderator

Oracle SQL Developer Migrations Getting Started

You can download SQL Developer at:
http://www.oracle.com/technology/software/products/sql/index.html

Regards
Michel

[Updated on: Thu, 28 May 2009 13:08]

Report message to a moderator

Previous Topic:	RMAN duplicate from ASM instance to NON-ASM instance
Next Topic:	Please help me recover this database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 14:16:35 CST 2024