November 7, 2010 at 1:33 pm
Hi,
I have been tasked with creating a reporting server. I have considered using transactional replication but I am not sure if it will meet my requirements.
My challenges are as follows:
I need to keep my production database as effiecient and as fast as possible.
The production database will only have 2 days worth of data and all data before that will be deleted.
The data needs to be replicated to the reporting database server before being deleted off the production database.
Will SQL Replication allow me to only replicate new data and neglect the deleted data. That way i will be able to achieve my goal.
If not, then what other options do i have,
Please help.
November 9, 2010 at 8:37 am
Replication can work. There is a "do not replicate deletes" and you can read about it here:
http://www.sqlservercentral.com/articles/Replication/3202/
Replication is minimal load. You could also use SSIS, but it would be a bunch of custom scripting to move things. Replication will take some effort to setup and monitor, but this can work well. Make sure you monitor it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply