Varbinary conversion / transfer

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Varbinary conversion / transfer

Postby mmetzger » Fri Nov 05, 2010 10:04 am

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!
mmetzger
 
Posts: 6
Joined: Fri Nov 05, 2010 10:00 am

Re: Varbinary conversion / transfer

Postby Moderator » Sun Nov 07, 2010 10:29 pm

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!
User avatar
Moderator
Site Admin
 
Posts: 314
Joined: Wed Oct 29, 2008 11:27 pm

Re: Varbinary conversion / transfer

Postby mmetzger » Mon Nov 08, 2010 5:19 am

Thanks for the response - I'll check with my client and see what we can provide test-wise.
mmetzger
 
Posts: 6
Joined: Fri Nov 05, 2010 10:00 am

Re: Varbinary conversion / transfer

Postby mmetzger » Mon Nov 08, 2010 1:55 pm

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!
mmetzger
 
Posts: 6
Joined: Fri Nov 05, 2010 10:00 am

Re: Varbinary conversion / transfer

Postby Moderator » Thu Nov 11, 2010 3:30 pm

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!
User avatar
Moderator
Site Admin
 
Posts: 314
Joined: Wed Oct 29, 2008 11:27 pm

Re: Varbinary conversion / transfer

Postby mmetzger » Fri Nov 12, 2010 5:25 am

Works great on our test data set - thanks!
mmetzger
 
Posts: 6
Joined: Fri Nov 05, 2010 10:00 am


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest