Hello,
I am trying to have a migration process for migrating all the SQL server objects to Vertica and along with data.
I have explored on Table, Views, Functions, Stored procedure migration from SQL server to Vertica. But I am not sure how triggers, packages can be migrated from SQL server to Vertica.
What I understand is there is no corresponding Objects in Vertica for Triggers and Packages. Can anyone please help me here to understand how this can be achieved ?
Appreciate help and support
Thanks
Vittal
Migration from SQL Server to Vertica
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Tue May 21, 2013 12:24 am
-
- Intermediate
- Posts: 87
- Joined: Wed Apr 25, 2012 8:10 am
Re: Migration from SQL Server to Vertica
Hi Vittalkini,
Vertica doesnt support Stored procedures, Triggers , Packages.
You can only transfer the database objects like Tables and Views from MSSQL to Vertica.
Thanks,
Raj
Vertica doesnt support Stored procedures, Triggers , Packages.
You can only transfer the database objects like Tables and Views from MSSQL to Vertica.
Thanks,
Raj
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1
Re: Migration from SQL Server to Vertica
Hello vittalkini,
Vertica has a feauture of External procedures which are limited by there functionality and also can be somewhat similar to Stored procedure though not so much flexible like them.
Vertica has a feauture of External procedures which are limited by there functionality and also can be somewhat similar to Stored procedure though not so much flexible like them.
You can migrate a stored procedure, by doing it the Shell scripting way.External procedures are simply executable files such as shell scripts, compiled code, code interpreters, and so on.