Moving records to offline database

2003-06-27 11:11:31 AM
Dear all,
I have to do maintenance task to my application. I need to move aged
records daily from an online (SQL Server 7) database table to an offline
one, and to delete those records from the online database. Does anyone have
simple sample code for performing this task? Code need not to be very
efficient as I would do that on non-peak hours.
Thanks in advance,