Mike Poe wrote:
> The designer of the SQL 2000 database decided to store binary data
> (images) directly in this table. When I attempt to replicate it to my
> PG database, SQL replication agent throws an error:
>
> The process encountered invalid column data in bcp file
> 'path\to\bcpfile.bcp'.
>
> I assume this has to do with the binary data in the table.
Hmm - what are the types involved at the PG end, and how is the data
formatted in the .bcp file?
I'd set up a sixth table with one row and one column and try replicating
that to make it easier to control.
--
Richard Huxton
Archonet Ltd