This is an open-ended question, where 5 peoples will give you 7 answers. I would say, - extract old data - see what you have to do to reformat/trim/merge them into new structure. You said, data structure is different, not just data format. - insert new data But, you already know that. -- William Park <opengeometry@yahoo.ca> On Fri, Jul 20, 2018 at 01:42:27PM -0400, Alex Volkov via talk wrote:
Hey Everyone,
I'm looking for a tool to transform (possibly migrate) data from one postgres db to another.
I have two postgres databases -- old (not normalized) has all the data and new (normalized with some major schema changes) has no data.
The new db has more tables and table relationship structured differently, some data residing in old db is in text column in csv format, whereas in new database it's a separate table, and so on.
I've been thinking of writing a script that would just transform data from one format to the other, but before writing a bunch of code that's going to be run exactly once, I'm wondering if there a tool out there which I can use to express one-way transformation rules for these databases.
Thanks,
Alex.
--- Talk Mailing List talk@gtalug.org https://gtalug.org/mailman/listinfo/talk