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?