I am importing data from mssql to postgres.
I am very pleased with the "Visual Importer" product. I do however have one problem I have not been able to resolve...
our system creates TableNames with proper casing, that is Uppercase and Lowercase letters in the table names. the Importer has no trouble locating these target tables and mapping the import. But when the import is running it fails on the insert with a (relation "tablename" not found). Looks to me like the importer expect the target database to be case insensitive and converts all table names to lowercase. I have a work around. I just rename my table before the import and back again after. but this is a real pain! and it takes my table offline while imports are in progress.
any help would be appreciated,
nathan.anderson@kellpro.com 
