On 2009-04-29, Stefan Sturm <stefan(dot)s(dot)sturm(at)googlemail(dot)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.