I have a SQL Server 2000 that has 6 databases (one for each production machine) which holds data for each part processed. I developed this mainly to start learning about SQL Server and management liked it, so they want to use it as a tool to look at the process on an “as needed” basis. What I haven’t developed yet is how to archive the data and then automatically delete it out of the database(s). The frequency of this archive/purge of the 6 DB’s is probably daily or weekly. I don’t think that there will be a need for on line access to this historical data and the archive can be in Access or Excel. The parties using this data aren’t using anyhing more advanced than that to analyze the data. From what I’ve looked at so far, DTS may be part of the answer.
Will anyone be so kind as to give me any ideas on where to start (or how to put it all together)? The time I have to spend on this “learning experience” is considerably less than when I originally started. That is why I’m soliciting help at this point.
Any help would be greatly appreciated.
Thank You for your attention.