Problem with data export when using the MSSQL Wizards

Report PGNP bugs.

Problem with data export when using the MSSQL Wizards

Postby takrl » Mon Aug 10, 2009 8:45 am

Hi,

thanks for the speedy fix to my first problem. Here's another one. When I use the "SQL Server Import and Export Wizard" (right click database -> Tasks -> Export data) to copy tables from MSSQL to postgres, I get an error.

-- Source DB is MS SQL 2005 SP2
-- Dest. DB is postgres 8.3.7
-- PGOLEDB build is 1.2.8.1145, 32 bit.

Behaviour is as follows:
The wizard gets as far as the final step, on running the script it goes as far as creating the destination table in the postgres db. Then there's three errors, see attached screenshot. A trace log is also included.

Two points to note:
-- I did use the "Use lowercase schema"-Checkbox.
-- The errors stay the same even if I edit the SQL manually to avoid upper case field names (not sure if that's the region the error lies in).

This one isn't as critical as the bit conversion error I had last week, I'm not using this wizard in production. However, the wizard is the easy way to test data export and import, so many people testing your driver with SQL Server are going to see this and may be turned away. In fact, I did see this when we tested the driver, but luckily did some further testing using other methods, which turned out to work fine.

Cheers

Michael
Attachments
debug.zip
Screenshot + trace log
(101.87 KiB) Downloaded 412 times
takrl
 
Posts: 3
Joined: Wed Jul 29, 2009 4:59 am

Re: Problem with data export when using the MSSQL Wizards

Postby Moderator » Mon Aug 10, 2009 7:25 pm

I have reproduced the issue and put it on the 'to-do' list.
Thank you!
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm

Re: Problem with data export when using the MSSQL Wizards

Postby Moderator » Wed Jan 27, 2010 12:13 am

Update:
This bug had been fixed a while ago.
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron