SQL Server to Vertica Migration

Moderator: NorbertKrupa

Post Reply
Ranjith.chowdary
Newbie
Newbie
Posts: 5
Joined: Thu Aug 01, 2013 12:44 am

SQL Server to Vertica Migration

Post by Ranjith.chowdary » Thu Aug 22, 2013 11:43 pm

Hello ,

We are trying to migrate from SQL Server to Vertica using SSIS. Did anyone try this approach?

Also with Datatype conversion is their a equivalent datatype in vertica for ntext and image datatype in SQL Server.

Please respond and thanks in advance.

User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: SQL Server to Vertica Migration

Post by becky » Fri Aug 23, 2013 8:31 am

Hey,

We did a conversion from SQL Server to Vertica... It's not all that easy. There is no equivalent datatype in Vertica for the ntext and image datatypes. The max size for a VARCHAR is 65000. If you have anything bigger you have to break the data up into separate columns. But in a database like Vertica, you probably shouldn't be storing this type of data. From what I've learned, there is no point in storing images in an analytics database. You can put meta data about an image in Vertica and do analysis on it. It's best to store pointers to images on disk.

I can try to help further if you need anything :)
THANKS - BECKSTER

Ranjith.chowdary
Newbie
Newbie
Posts: 5
Joined: Thu Aug 01, 2013 12:44 am

Re: SQL Server to Vertica Migration

Post by Ranjith.chowdary » Fri Aug 23, 2013 6:14 pm

Thanks Becky for the quick reply. For the migration what was the ETL tool you guys used?.

User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: SQL Server to Vertica Migration

Post by becky » Fri Aug 23, 2013 8:06 pm

We ended up just dumping everything to text files, and then loading them into Vertica with the COPY command. It was the fastest way we found.
THANKS - BECKSTER

Post Reply

Return to “Vertica Migration”