Migration from SQL Server to Vertica

Moderator: NorbertKrupa

Post Reply
vittalkini
Newbie
Newbie
Posts: 1
Joined: Tue May 21, 2013 12:24 am

Migration from SQL Server to Vertica

Post by vittalkini » Fri May 31, 2013 8:40 pm

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

rajasekhart
Intermediate
Intermediate
Posts: 87
Joined: Wed Apr 25, 2012 8:10 am

Re: Migration from SQL Server to Vertica

Post by rajasekhart » Tue Jun 11, 2013 11:20 am

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
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Migration from SQL Server to Vertica

Post by nnani » Tue Jun 11, 2013 12:05 pm

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.
External procedures are simply executable files such as shell scripts, compiled code, code interpreters, and so on.
You can migrate a stored procedure, by doing it the Shell scripting way.
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Migration”