SQL Server

Moderator: NorbertKrupa

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

SQL Server

Post by becky » Sat Apr 28, 2012 11:50 am

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 :?:
THANKS - BECKSTER

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: SQL Server

Post by jpcavanaugh » Mon Apr 30, 2012 10:18 pm

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

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

Re: SQL Server

Post by becky » Tue May 01, 2012 10:31 pm

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

DataWhisperer
Newbie
Newbie
Posts: 16
Joined: Fri May 11, 2012 12:25 pm

Re: SQL Server

Post by DataWhisperer » Sat May 12, 2012 8:42 am

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.

Post Reply

Return to “Vertica Migration”