Wednesday, 11 September 2013

SQL Data synchronization between production and reporting server

SQL Data synchronization between production and reporting server

I have one production server which will store data from day 1 (latest
data) up to day 90. I will move day 91 data to reporting server everyday
when new data enters on production server. My reporting server will keep
365 days of data. Production will keep 90 days data.
There are still some daily data update in my production for the total 90
days data. How should I synchronize the changes in production data (90
days) with my reporting data ( 365 days) ?
Please advise.
And for the day 91 data import to reporting, is it the best way to use
SSIS import wizard?
Thanks in advance.

No comments:

Post a Comment