The Vertica Database Forums

My requirement is to export data in sqlserver to vertica.
Iam able to export the data using COPY from LOCAL command.

Steps which i followed is as follows

1. Get the data from table in .net datareader object
2. loop through the reader object and will create a csv file
3. export the csv file using COPY from LOCAL command.

All these works fine.

My issue is that my one of my column from the table is timestamp and in the reader object iam getting as byte[] and i want to insert this byte[] into a binary field in corresponding table in vertica.

how can i do this ?

Thanks in advance
Sushanth.B

Hi sushanth,

I'm not sure I understand your question. What do you mean by a byte[]? Is this in reference to a column having the data type BIT?