Page 1 of 1

Migration from SQL Server to Vertica

Posted: Fri May 31, 2013 8:40 pm
by vittalkini
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

Re: Migration from SQL Server to Vertica

Posted: Tue Jun 11, 2013 11:20 am
by rajasekhart
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

Re: Migration from SQL Server to Vertica

Posted: Tue Jun 11, 2013 12:05 pm
by nnani
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.