OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Migration (oracle 10g,Mysql 5.5)

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

Migration [message #576209]

Fri, 01 February 2013 07:35

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Dear all,
I need to migrate data from oracle server to MySql.So please guide me..

Report message to a moderator

Re: Migration [message #576215 is a reply to message #576209]

Fri, 01 February 2013 07:46

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you have no idea, hire a consultant to do it.

Regards
Michel

Report message to a moderator

Re: Migration [message #576345 is a reply to message #576215]

Sun, 03 February 2013 22:38

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Anyone having idea about how to copy data betweem oracle server and data file in a user specified format.

Report message to a moderator

Re: Migration [message #576346 is a reply to message #576345]

Sun, 03 February 2013 22:40

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Because i am doing migration between MSSQL and MySql.In MSSQL we are using bcp command line utility to copy data between MSSQL and data file.

Report message to a moderator

Re: Migration [message #576347 is a reply to message #576346]

Sun, 03 February 2013 23:10

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

>I need to migrate data from oracle server to MySql.So please guide me..
>Because i am doing migration between MSSQL and MySql

Please make up my mind regarding source & target DBs.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Migration [message #576371 is a reply to message #576347]

Mon, 04 February 2013 03:55

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Hi,
I am doing migration between MSSQL and MySql for one project.For our upcoming project we need to do migration between oracle and MySql.

Report message to a moderator

Re: Migration [message #576374 is a reply to message #576371]

Mon, 04 February 2013 04:10

Littlefoot
Messages: 16923
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I never did that. Though, got tired of reading your cries and Googled a little bit for you. Have a look at this words (people used Pentaho Data Integration).

Report message to a moderator

Re: Migration [message #576377 is a reply to message #576371]

Mon, 04 February 2013 04:33

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

siraj.accet@gmail.com wrote on Mon, 04 February 2013 10:55

Hi,
I am doing migration between MSSQL and MySql for one project.For our upcoming project we need to do migration between oracle and MySql.

Migration does not only mean copy tables and data to another table, it also means rewriting the application for the new rdbms.

Regards
Michel

Report message to a moderator

Re: Migration [message #576384 is a reply to message #576377]

Mon, 04 February 2013 06:43

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Hi cadot,
I know migration involves lot of process.But as a database developer this is my job.

Report message to a moderator

Re: Migration [message #576385 is a reply to message #576384]

Mon, 04 February 2013 06:44

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Hi cadot,
We have changed application.I need to support for that application by migrating data and tables.Thats it...

Report message to a moderator

Re: Migration [message #576386 is a reply to message #576385]

Mon, 04 February 2013 07:06

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Hi cadot,
For your info,Already i am involving migration process.

Report message to a moderator

Re: Migration [message #576388 is a reply to message #576386]

Mon, 04 February 2013 07:16

siraj.accet@gmail.com
Messages: 37
Registered: December 2012
Location: CHENNAI

Member

Anyone having idea about how to copy data betweem oracle server and data file in a user specified format like bcp command in MSSQL.Is there any other commands avail in oracle?

Report message to a moderator

Re: Migration [message #576390 is a reply to message #576388]

Mon, 04 February 2013 07:46

Littlefoot
Messages: 16923
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, did you research what I suggested previously?

[Updated on: Mon, 04 February 2013 07:46]

Report message to a moderator

Re: Migration [message #580882 is a reply to message #576390]

Fri, 29 March 2013 02:53

Alivewolf
Messages: 1
Registered: March 2013
Location: India

Junior Member

Hi SIraj,

Ae you alone doing the migration project, yet another projects are lined up that's cool, If needed a consulting let me know, anyway be thankful to littlefoot.

Report message to a moderator

Re: Migration [message #580883 is a reply to message #580882]

Fri, 29 March 2013 02:56

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not the place to ask for job.
Either help here for free, either leave.

Regards
Michel

Report message to a moderator

Previous Topic:	Create tabled of type Varray
Next Topic:	Dynamic Rows Generate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 00:51:03 CDT 2013

Total time taken to generate the page: 0.29064 seconds