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.
I don't know of a tool but here are a couple of thoughts if there isn't one.
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.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply