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
SQL Server
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: SQL Server
Are you looking to copy the structure and data or just move the data over?
Re: SQL Server
Thanks for responding. We're looking to move both the structure and data.
THANKS - BECKSTER
-
- Newbie
- Posts: 16
- Joined: Fri May 11, 2012 12:25 pm
Re: SQL Server
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.
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.