Обсуждение: Export Data from one DB and Import into a new DB

Hello,

we are changing the structure of our database from a new release.
Now we need to export large amounts of data and import it into the new
db( with a new structure).

Are there any tools( for osx ) to support me doing this?

Thanks for your help,
Stefan Sturm

On 2009-04-29, Stefan Sturm <stefan.s.sturm@googlemail.com> wrote:
> Hello,
>
> we are changing the structure of our database from a new release.
> Now we need to export large amounts of data and import it into the new
> db( with a new structure).
>
> Are there any tools( for osx ) to support me doing this?

last time I had to convert a database I loaded it into postgres and
used "SQL" and plpgsql functions.

then dropped the functions, columns and tables  I didn't want to keep around.

things like

 INSERT INTO somenewtable SELECT somequery...

are very powerfull tools

The hardest bit was dealing with the inconsistencies in the input data.