Hi,
I've problem with migrating postgresql
data to another db, ie cloudscape or
mimer ..
It happened because dumped data using
pg_dump doesn't have standard SQL format.
so, not every db can not import that data
even though it's already in plain text format
I've tried to make 2(two)dumped sql files
which are schema and data version.
But to edit it manually ? it seems not
wise enough for a 300 tables schema !
I wonder is there any tools provided
by postgresql or others that allowed
migration process easier ??
Thank you very much,
--f4r
I've problem with migrating postgresql
data to another db, ie cloudscape or
mimer ..
It happened because dumped data using
pg_dump doesn't have standard SQL format.
so, not every db can not import that data
even though it's already in plain text format
I've tried to make 2(two)dumped sql files
which are schema and data version.
But to edit it manually ? it seems not
wise enough for a 300 tables schema !
I wonder is there any tools provided
by postgresql or others that allowed
migration process easier ??
Thank you very much,
--f4r