Varbinary conversion / transfer

More
9 years 9 months ago #536 by mmetzger
mmetzger created the topic: Varbinary conversion / transfer
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!

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #539 by Moderator
Moderator replied the topic: Re: Varbinary conversion / transfer
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!

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #540 by mmetzger
mmetzger replied the topic: Re: Varbinary conversion / transfer
Thanks for the response - I'll check with my client and see what we can provide test-wise.

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #541 by mmetzger
mmetzger replied the topic: Re: Varbinary conversion / transfer
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!

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #624 by Moderator
Moderator replied the topic: Re: Varbinary conversion / transfer
We have fixed the issue in 1.3.0.2196. Please download the trial version with the fix from: [url:1rbbepao]http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68[/url:1rbbepao].

Thank you!

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #625 by mmetzger
mmetzger replied the topic: Re: Varbinary conversion / transfer
Works great on our test data set - thanks!

Please Log in or Create an account to join the conversation.

Time to create page: 0.140 seconds
Powered by Kunena Forum