April 7, 2011 at 8:01 am
Just needed some suggestions on creating an archival process. I have looked at some of the scripts that are on sql server central, but, I have approximately 188 tables that need to have rows deleted and rows inserted into the archival database. I'm thinking I need to take advantage of Dynamic SQL since I've got so many tables to archive data from. Any suggestions would be greatly appreciated.
April 7, 2011 at 10:59 am
Rather than going to dynamic SQL, have you looked into using SSIS. It's a great ETL tool and you can automate it's behavior, it'll work with referential constraints, there are examples out on the web of how to use it just this way... That's the choice I'd take.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2011 at 1:03 pm
Thanks. I've used SSIS but not in that way. I will take a look out on the web.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply