Oracle to vertica migration

Moderator: NorbertKrupa

Post Reply
venkisagala
Newbie
Newbie
Posts: 2
Joined: Tue Feb 05, 2013 6:22 am

Oracle to vertica migration

Post by venkisagala » Tue Feb 05, 2013 6:42 am

Hi,

We are planning to Migrate Oracle Db to Vertica DB. Please provide the information about the Migration Process and how to handle Oracle Database objects like Stored procedures,Triggers,Packages ,Db links ...etc in vertica.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Oracle to vertica migration

Post by JimKnicely » Tue Feb 05, 2013 7:53 pm

Hi!

Welcome to the forums!

Your topic is a VERY broad topic :? Do you have any specific questions? There isn't an easy way to convert an Oracle database to Vertica. For instance, Vertica does not have any support for procedures, functions, triggers and packages in the same sense that you are used to in Oracle. Moving the data won't be too difficult.

But, if you have more specific questions, please let us know and we'll try to help!
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: Oracle to vertica migration

Post by sarah » Wed Feb 06, 2013 2:25 am

Hi,

I can offer help here too! We've moved an Oracle database into Vertica, although we did not have a whole lot of code stored in the database.
Have a GREAT day!

sonynavi
Newbie
Newbie
Posts: 7
Joined: Sat Dec 15, 2012 11:08 am

Re: Oracle to vertica migration

Post by sonynavi » Mon Feb 18, 2013 2:34 pm

Sarah, How did you handle the STored Procedures in Oracle to Vertica. Could you please share

Ispirer SQLWays
Newbie
Newbie
Posts: 1
Joined: Sat Apr 25, 2015 10:08 am

Re: Oracle to vertica migration

Post by Ispirer SQLWays » Sat Apr 25, 2015 10:18 am

Hi!
The migration to Vertica is quite a specific migration direction, but even it can be automated! Our tool SQLWays can cope with this task, as it is very flexible and customizable. Our technical team has relevant experience and can offer you some options. You can find more information at the following link: http://www.ispirer.com/products/vertica-migration

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Oracle to vertica migration

Post by adrian.oprea » Mon Apr 27, 2015 2:11 pm

sonynavi wrote:Sarah, How did you handle the STored Procedures in Oracle to Vertica. Could you please share
Why would you wanna move all you Stored Procs to Vertica ? Are you replacing your transactional db with Vertica ? You know that Vertica is a columnar DB it won't handle good your transactional workload.
trying so hard !!!

Post Reply

Return to “Vertica Migration”