Migrating data between dbs with different schemas

[stpro13]

Hi all,
I have a database (postgresql) designed with a particular schema. I have now set up a new postgresql database to store the same data (possibly some new info added) but has a different schema. (Basically, we have designed a new application and tweaked the database schema). The new db is set up using Java5 Java Persitence Architecture (annotations etc). The problem is we need to migrate the data from the old db to the new db. Is there an easy way to do this (other than manually entering the data).
Cheers steve

[MMcCarthy]

This questions is being moved from here to the Java technical forum.

ADMIN

[r035198x]

Hi all,
I have a database (postgresql) designed with a particular schema. I have now set up a new postgresql database to store the same data (possibly some new info added) but has a different schema. (Basically, we have designed a new application and tweaked the database schema). The new db is set up using Java5 Java Persitence Architecture (annotations etc). The problem is we need to migrate the data from the old db to the new db. Is there an easy way to do this (other than manually entering the data).
Cheers steve

You mean besides writing some data migration routines? In that case you'll have to check the features of postgresql.