Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-12 : 11:10:57
|
Bruce writes "Greetings, my question revolves around my need to offload data out of a production table into an offline data warehouse table.
I have a table that is always being updated with activity information. This information needs to be offloaded at customer determined intervals from the production table into an offline table for reporting and such.
What I would really like is that once the information is moved from the production table to the offline table that the production data is deleted from the production table to keep its size at a minimum.
I have thought of doing SQL Replication but I don't think this is the right road to travel.
I have been thinking of developing a custom DTS application and schedule it to run, but I have not found good information on how to program a DTS application.
Cold it be as simple a stored procedure that moves the data then deletes the old data.
Any thoughts or suggestions would be greatly appreciated.
Thanks,
Bruce Wallwin
Sr. Software Engineer
Rockwell Automation" |
|
|
|
|
|
Best way to offload production data to warehouse