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 184.108.40.2065, 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.