Home Forums Reply To:

  • July 20, 2022 at 2:04 pm

    #4066001

    wrote:

    Does anyone know any good database archive software/tools out there?

    We are looking into a tool that will archive data off of the OLTP databases into an archive database. The tool will allow you to purge or move data based on dates.

    Thanks.

    I don't know of such a tool.  I'm sure they exist but don't know of one.

    I'll also state that even if you find a highly recommend tool, it's going to be incredibly difficult to get it to work unless you have all the proper DRI (basically, Foreign Keys) defined on every table so the software would be able to correctly identify the dependencies between related tables and the correct order of deletion for the source database once the data has been copied to the archive database.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)