Hello, MC.
Only human can do this. Moreover, if "data integrity is very
important".
Regards
You wrote:
MM> Hi,
MM> I'm looking to migrate psql db1 to a psql db2 that has a different structure
MM> even though 70% would be the same. I'd need a tool that allows me to map
MM> field to field and then migrate the data from one db to another. Needless to
MM> say that preserving data integrity is very important.
MM> Any good idea what would be the best approach ?
MM> Thanks,
MM> Constantin
MM> http://www.goodstockimages.com
MM> ---------------------------(end of
MM> broadcast)---------------------------
MM> TIP 4: Have you searched our list archives?
MM> http://archives.postgresql.org
--
With best wishes,
Pavel mailto:pavel@microolap.com