Online Backup of Multiple Databases - Forum - OpenEdge Deployment - Progress Community

Online Backup of Multiple Databases

 Forum

Online Backup of Multiple Databases

  • "but the codebase is littered with DBNAME.TABLE.FIELD phrases, each of which would need visiting in order to fix them."

    There's a quick & dirty fix for that too:

    Set up aliases using CREATE ALIAS statements in your startup procedure, to redirect the obsoleted database names to the single remaining connection.

    Be sure to test though: Since everything goes over a single connection instead of multiple ones, there may be corner cases where concurrency, conguency and transaction flow can change.

    The bigger headaches will show if the same table names appear in multiple databases, because then you may need to rename tables before you can merge into 1 database.

  • "The bigger headaches will show if the same table names appear in multiple databases, because then you may need to rename tables before you can merge into 1 database."

    This is of course the other, bigger issue we have... How could I forget that?!

  • @james: if you are writing to only one of the databases, why do you have to synchronise the backups?

    and: how many times has not synchronising them caused a problem in the past for this legacy system?

    are you fretting about a problem you don't actually have?

  • Hi - we don't synch backups. The OP does though.