Next Meeting: Wed, Sep 17 2014
September: Strategies and tools for Reporting Services (SSRS) content
Event Type: In-Person
Olympia Area SQL Server User group meeting.
Event Time : Wed, Sep 17 2014 14:30 - 16:30 Pacific Daylight Time
310 Israel Road SE
Strategies and tools for Reporting Services (SSRS) content
Carla Sabotta and Craig Guyer .
Approaches and tools for Reporting Services (SSRS) content migration
Come learn the different approaches for copying/migrating SQL Server Reporting Services (SSRS) content from one reporting environment to another.
Understanding how to copy SQL Server Reporting Services (SSRS) content items is important for a report server administrator, whether you need to complete a server upgrade, platform migration (say Native mode to SharePoint mode), or to prepare as part of an overall disaster recovery strategy.
We will review the approaches to:
1) SSRS Native mode database migration.
2) SSRS SharePoint mode database migration
3) Item only migration using the SSRS migration tool and rs.exe script.
4) Validation of the migration, steps that are useful for post migration or simply post installation.
Our core focus for this session is #3 and #4 as we think there is representative content already for the other items...but you tell us if you disagee.
We will demonstrate a sample rs.exe script that migrates content between servers and is available for download.
We would also like to hear your thoughts on content gaps to make Reporting Services management easier and more efficient.
We will review the key documentation available to assist you in learning more.
About Carla Sabotta and Craig Guyer:
Carla is a writer for Microsoft SQL Server Reporting Services (SSRS). She writes articles for MSDN/TechNet as well as creates videos, tutorials, quizzes, and samples. She’s also written documentation for SSIS, application development software and business management software.
Craig is a Senior Content developer at Microsoft, working on content and education related to SQL Server Reporting Services and PowerPivot for SharePoint. Previous posts at Microsoft included Program Manager (PM) on the SSRS team, PM on the MSN Money team, and PM with HR team working on SAP.