May 2, 2003 at 4:22 pm
Dear All,
I have to transfer data from production server to datawarehousing server, both are SQL Server 7 SP4 .
The requirement is that the production server should retain the data/transactions of only 30 days.
The transaction which was done before 30 days {OR till yesterday (I think the better choice) } should be transfer to the datawarehousing system, having RAID-1.
Thus I need to develop an SP that run at every night, updating the data datawarehousing at Server.
It should update all the addition/modification done at the production database.
Any recommendations/views, how to achieve it.
Thanks,
May 2, 2003 at 6:44 pm
The processes that extract data from production database, transform and load them into your DW depend on your business requirements.
See "Extracting Data from Operational Systems", "Cleansing and Transforming Data", "Loading Data into the Data Warehouse Database" in BOL to familar with the ETL concept and tools before you start.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply