Big Data since way back, but any Data will do.
Thanks for the help. We are also moving from Sql Server to Redshift. Have you changed you export process since the ACCEPTINVCHARS option has been added to the COPY command?
Hi Brock, I'd like to think I had some influence on the addition of ACCEPTINVCHARS! I'm sure others were bugging them about it though.It certainly resolves my issue with 0xBFEFEF but I haven't tested NUL or DEL chars as my SQLCMD extracts don't contain them.Also, FYI, they've added support for LZO compressed sources so I'm experimenting with that to see if it speeds up the extracts at all.Joe
Any reason why you did not consider Vectorwise or Paraccel?Full disclosure: I work for Actian.