Thread: transfering data between DB's

transfering data between DB's

From
johnf
Date:
Happy Holidays,
2 developers.
Two DB's one on my workstation and the other DB on a different workstation.

The problem:
As one developer makes changes to his DB and those changes can be either data
or structure - the other developer needs to update his DB.

If the changed table is backed up and then restored on the a different
workstation the sequence data is lost and does not work correctly.

I'm sure this is not a new problem for the software guys developing postgres
applications.

When just data changes occur I'd like some way to transfer just the data
between DB's.  And I would like a simple way to setup structure changes
between the tables.

So how is it handled?
--
John Fabiani