The Vertica Database Forums

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.

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 Becky for the quick reply. For the migration what was the ETL tool you guys used?.

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.