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.
Oracle to vertica migration
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Oracle to vertica migration
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!
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Oracle to vertica migration
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.
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!
Re: Oracle to vertica migration
Sarah, How did you handle the STored Procedures in Oracle to Vertica. Could you please share
-
- Newbie
- Posts: 1
- Joined: Sat Apr 25, 2015 10:08 am
Re: Oracle to vertica migration
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
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
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: Oracle to vertica migration
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.sonynavi wrote:Sarah, How did you handle the STored Procedures in Oracle to Vertica. Could you please share
trying so hard !!!