The Vertica Database Forums

Hi!

Anyone know of any tools that will help copy databases from SQL Server to Vertica?

I've been manually editing scripts, but there has to be a better way

Are you looking to copy the structure and data or just move the data over?

Thanks for responding. We're looking to move both the structure and data.

Unfortunately there is no "nice" way to do this, especially w/ IDENTITY or AUTO_INCREMENT fields (as you can't insert to them).

You could export all the data structures and run sed over them to convert the data types over, then do massive data extract to a CSV file (or equiv) and then COPY command everything in, but this is assuming your not using IDENTITY or AUTO_INCREMENT for your PK/FK as they may break, or you modify your code to handle these fields.