You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by hadoop hive <ha...@gmail.com> on 2014/10/21 11:36:31 UTC

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 appreciated

Thanks
Vikas Srivastava

Re: Migration of metastore tables from mysql to oracle.

Posted by Sanjay Subramanian <sa...@yahoo.com>.

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 <ha...@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