April 26, 2008 at 11:32 am
We have a real-time system in sql server 2005. We would like to create a replication for this real-time system and use that as the base for the ad-hoc reporting using Report Builder and Reporting Services.
The options
1. How to back up the real-time database to another sql server 2005 on hourly basis.
like the reporting server should be one hour behind the current real-time system.
Can I use replication Services in sql server 2005.
2. For Ad-hoc Reporting, the solution we are thinking is to create models for each business areas and use reporting builder as the tool to generate reports on fly and save to the report manager .
3. Create pre-defined reports using Reporting Services in Sql server 2005.
I would like to discuss a better solution for this scenario.
Looking forward to hear the best one !!
Thanks,
Matt.
May 1, 2008 at 1:51 pm
Hi Matt,
You can set up transactional replication from the production database to the reporting one. It's not so complex, read the BOL and you'll succeed. Reporting Services is a good idea, however, if you're in a planning phase and you're to heavily create reports, I recommend you to wait a bit for the SQL2008 Reporting Services as it's way more robust than the SS2K5's. Unfortunately, the report designer will be shipped a bit later than the RTM, but still, it may be worth it...
-- Erik http://blog.rollback.hu
May 1, 2008 at 5:51 pm
Thanks,
Is there any third party tools similiar to Report builder to generate Ad-hoc reports. ?
Thank you again
Matt.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply