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
