Database archive tool

Question

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

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

callen-557064 SSC-Addicted Points: 460 More actions · Answer 1

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.

Kavita-284259 SSC Veteran Points: 209 More actions · Answer 2

Hello,

Did you find a good tool to archive your DB?

Thanks

Kavita

Steve Jones - SSC Editor SSC Guru Points: 738043 More actions · Answer 3

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

Cookies on SQLServerCentral