runal_jagtap (3/18/2013)
Example -We have a DB which have loads of data & we want to archiev it to some Server in such a way that
Scenario - Source DB have 5 yrs Data in it, we want to move the 5 yrs Data to Destination DB, & then will keep only one month data in Source DB, that means on monthly basis we will have less data in Sorce DB.
Please help me a best approach??
Will you ever have the need to access the data that's more than a month old through a GUI or stored procedure?
--Jeff Moden
Change is inevitable... Change for the better is not.