Problem migrating from SQL Server 2005 to PostgreSQL 8.3


I have tried to migrate from Microsoft SQL Server 2005 to PostgreSQL 8.3 using the migrateDB.bat tool. The PgSQL database is located on a linux box.

When I run the command 'migratedb migrate' it first checks connections, create target schema in PostgreSQL and then exports all data. When it tries to import data to PostgreSQL the following error occurs:

Mon Mar 16 14:10:09 CET 2009                                   agent :         2 : 50% Error accessing target metadata for agent.ID
Caused by: ResultSet not positioned properly, perhaps you need to call next.
Error importing data. Last processed row #2
Caused by: null
Critical error has occurred during migration.


The PostgreSQL log file does not show anything interesting.

The agent.csv file contains two rows of which none looks particular suspect.

Do you have any idea what is causing this?


1 comment
Comment actions Permalink


This seems to be a bug that we already have filed:

We are still investigating the issue, it seems that PostgreSQL sometimes cares about case of the column names.

Please watch the issue so that we can ask for further details on the issue and notify you when the issue is fixed.

Sorry for the inconvenience.

Best regards,

Yegor Yarko
Project Manager (TeamCity)
JetBrains, Inc
"Develop with pleasure!"


Please sign in to leave a comment.