Re: Binary data migration from MSSQL

Roman Fail wrote:
> Thanks for the idea, Joe. I wrote a 'varbinary-to-octal_string' UDF on the
> MSSQL Server that I could call within a query on the bcp command line.
> After some tweaking, it worked great and takes about an hour to dump all 20
> million rows to text (which I think is pretty fast!).
>
> Wes Sheldah suggested modifying the bcp output with a perl script, but I
> opted not to do it that way. Although I don't know perl, I could have just
> as easily used Java. The drawback of doing it this way is that it's harder
> for others to follow if there is another language involved. I know
> everyone who wants to do this will already have a MSSQL server, and that's
> all you need to create the modified file.
>
> I'd be happy to write up what I did and contribute it to techdocs, if
> someone would let me know where to send the document. I looked around on
> the techdocs site and didn't see any instructions. I'm still curious why
> the binary data won't migrate using pgAdminII, but I guess I'll ask that
> question on another list.

I think Justin Clift is the right person to help you there -- Justin?

Joe