Migration of metastore tables from mysql to oracle.

2014-10-21 Thread hadoop hive 
Hi folks,

I have a requirement where I need to migrate metastore tables from mysql to
oracle.

Is there any who already performed this kind of activity.

Any help will be appreciated

Thanks
Vikas Srivastava

Re: Migration of metastore tables from mysql to oracle.

2014-10-21 Thread Sanjay Subramanian 
First question, Why are u migrating to Oracle ? Since u never store data on 
Hive Metastore MYSQL is a great choice. 

I have done a MYSQL to MYSQL transfer From the source DB mysql dump, it should 
be possible  to mod any Oracle required syntax right ?


  From: hadoop hive hadooph...@gmail.com
 To: user@hive.apache.org 
 Sent: Tuesday, October 21, 2014 2:36 AM
 Subject: Migration of metastore tables from mysql to oracle.
   
Hi folks,I have a requirement where I need to migrate metastore tables from 
mysql to oracle.Is there any who already performed this kind of activity.Any 
help will be appreciatedThanks
Vikas Srivastava