Post reply

Database archive tool

  • May 12, 2022 at 8:24 pm

    #4032027

    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.

  • May 12, 2022 at 8:31 pm

    #4032030

    I don't know of a tool but here are a couple of thoughts if there isn't one.

    1. Create a stored procedure which loops through all the tables and uses a parameter, like a date, to insert the data into the destination database table and then deletes the data from the source database.
    2. Use SSIS to create a package which essentially does the same thing.

  • May 20, 2022 at 11:15 am

    This was removed by the editor as SPAM

  • July 16, 2024 at 8:00 am

    #4436479

    Hello,

    Did you find a good tool to archive your DB?

    Thanks

    Kavita

     

  • July 16, 2024 at 3:53 pm

    #4436695

    I don't know of anything, as mapping data in a db and ensuring it's not missing something or removing something needed, is a complex problem.

    Most people do this with simple insert..select scripts from one db to another. Or with an ETL tool

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply