| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | MC Moisei <mcmoisei(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Mapping/DB Migration tool |
| Date: | 2006-07-25 19:31:40 |
| Message-ID: | 8F0CB612-AF5B-4B0C-BA20-33DEC2EE3C10@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jul 25, 2006, at 2:59 PM, MC Moisei wrote:
> I'm looking to migrate psql db1 to a psql db2 that has a different
> structure even though 70% would be the same. I'd need a tool that
> allows me to map field to field and then migrate the data from one
> db to another. Needless to say that preserving data integrity is
> very important.
I'm not aware of any migration tool to help on this (other than a
good SQL editor ;). It seems the best approach is to load an exact
copy of db1 and then write a script to transform it into db2,
creating, dropping, and altering the structure as necessary.
I think there are some tools (EMS?) that can compare schemas and
generate the SQL to transform db1 to db2. But there is a good chance
an automated approach like this will not transform data the way you
want.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2006-07-25 20:07:55 | Re: ECPG usage |
| Previous Message | Pavel Golub | 2006-07-25 19:09:31 | Re: Mapping/DB Migration tool |