Problem with data export when using the MSSQL Wizards

More
12 years 5 months ago #77 by takrl
Hi,

thanks for the speedy fix to my first problem[/url:2hu1upqo]. 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, [i:2hu1upqo]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[/i:2hu1upqo]. 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:

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

More
12 years 5 months ago #78 by Moderator
I have reproduced the issue and put it on the 'to-do' list.
Thank you!

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

More
11 years 11 months ago #228 by Moderator
Update:
This bug had been fixed a while ago.

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

Time to create page: 0.049 seconds
Powered by Kunena Forum