[GTALUG] looking for a tool to transform table relationships

[William Park]

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 at 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 at gtalug.org
> https://gtalug.org/mailman/listinfo/talk