O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix B. Transactional Replication for Reporting Services

The first concern of any report developer—as far as report development is concerned—is how to implement a reporting solution without negatively impacting the existing data infrastructure. Reporting requires significant resources, process and infrastructure-wise. You cannot just build a SQL Server Reporting Services (SSRS) system and slap it in your primary production SQL Server OLTP. It just doesn't work that way.

As a developer, your highest concern is to steer clear of any possible conflict with the performance of any production databases. You should be wary of the implications of building a reporting system in your environment.

An ideal reporting delivery project usually involves the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required