Varbinary conversion / transfer

[mmetzger]

We're looking to use PGNP to migrate a significant amount of data from SQL 2008 to pg9.0.1 (using Import / Export data) and we're hitting a problem with a varbinary column being transferred properly. The data type is correctly set on the destination db (bytea), but the data does not appear to be inserted properly.

Is there any way to debug this or try a different setting? We've tried both the 2008 and 2005 settings in the advanced connection properties to no avail.

Thanks!

[Moderator]

We have not been able to reproduce the issue. Could you please send us the table schema and some test rows to help reproduce the issue?

Thank you!

[mmetzger]

Thanks for the response - I'll check with my client and see what we can provide test-wise.

[mmetzger]

Ok, here's a table creation script (on SQL 2008 R2)

CREATE TABLE [dbo].[test](
[ID] [bigint] NOT NULL,
[BinValue] [varbinary](4) NOT NULL,
[LastDate] [date] NOT NULL
) ON [PRIMARY]

Data for the table is as follows:

ID,BinValue,LastDate
2373038152,00000001,2005-08-24 00:00:00
560427871,000BBB00,2004-01-18 00:00:00
7736020080,00000AAA,2010-09-02 00:00:00
7922126892,A100B601,2010-09-02 00:00:00
4693951652,FFEEDDCC,2007-01-16 00:00:00

Using "Import & Export Data (64-bit)" completes successfully but the resulting table on Postgres does not show any data on the bytea column.

Thanks!

[Moderator]

We have fixed the issue in 1.3.0.2196. Please download the trial version with the fix from: http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68.

Thank you!

[mmetzger]

Works great on our test data set - thanks!