I have several ideas of how I would like to do this, but I thought I would
throw this one out here for the masses to comment on.
I have a production database that has a table used for logging activity
information. This table is a highly utilized table by a run-time
application. My goal is to off load the data out of this table into a
offline table that can be used for reporting and such.
The goal I am trying to acheive is this:
1. I want this offline table to be in the same physical database as the
2. I want an efficient way to select rows from the production table then
insert those rows into the offline table and delete the copied rows out of
the production table.
I am thinking that using DTS and creating a scheduled package is the best
way to accomplish this.
Has anyone had a similar problem to solve, if so how did you find it best
Thank you in advance for any comments or help.
Sr. Software Developer