Saturday, 3 June 2017

SSRS Migration Between Servers

Hi Folks!!!!!

This post is yet another add on to the last post of  Deletion of SSRS Report from Report Manager

However this time will learn how to migrate reports dynamically from one report server to another, say for e.g. from Production server to development server.

Again, use the concept of RS.exe utility to perform the activity.

Let's start with example

Example
             
All the reports of folder TEST on Report Manager of Production Server <ReportServer1> will be moved to folder TEST on Report Manager of Development Server <ReportServer2>

Pre-Requisites

  • SQL Server client tools must be installed on your machine.
  • RS.exe utility must be installed
  • Destination folder must be available (if not available, must create) at destination report manager.
Procedure

Step 1 - Create Folder TEST on Report Manager of ReportServer1, if not exists.

Step 2 - Use VB script to create script of migrating report, for your reference i have attached the script file (this file is available at Microsoft Site)
             
Step 3 - Create BAT file named MigrateReport.bat with below CMD command 



Step 4 - Place script (ssrs_miration.rss) and bat file (MigrateReport.bat) at same folder (optional).

Step 5 - Open CMD command and execute the MigrateaReport.bat file. all the reports for that folder will be migrated with status against every report migration.

Remarks
  • Shared Dataset created using credentials will not be be copied.

Author - Feel free to ask query if you have any

Thursday, 9 February 2017

Deletion of SSRS Report from Report Manager

Hi Folks!!!

I am back with yet another interesting and fascinating topic.


Sometime we came across tedious but important job of deletion of obsolete report from Report Manager though it is very helpful mainly for management and for some extents to developer as well.


But in fact, aforementioned task is very cumbersome if we delete each and every report via traditional way (manually deleting from report manager one by one).


One of the handful method is deleting report with the help of RSS file, herein i am describing the steps to perform the activities.


Step 1 - Create .RSS file, for example TestDelete.rss and placed at any location where you are comfortable.




Step 2 - Use VB script and write above mention code in RSS file.


Note - /Report_Test/TestReport  - Root folder in Report Manager i.e. in this case, we have folder Report_test at root on Report Manager and testReport is rdl file inside it.


Step 3 - With the help of CMD command, we can delete above mention report, CMD as below




This will delete test report from report manager.


You might be thinking, aforementioned process will only delete one report at a time, and yes, you are correct, but a little tweaking in script will delete multiple report at one go.


Just have to include rs.DeleteItem row in script equivalent to number of report to be deleted.


How to proceed

Task - To delete multiple reports

Steps -


1. Introduce rs.DeleteItem row with required reports in RSS file

2. Execute same CMD command as above



Output - Both reports are deleted.



There are many more methods to delete reports dynamically, i found this one is good.



Author - Feel free to ask if you have any query.