Tuesday, 8 September 2015

Migration Options For SSRS

Migrating of reports from one SSRS version to another is now a very common requirement. 

There are few tools available in market which can make help in migration process 

Here is in this article i tried to list down their pros and cons -  

  1. Using SSRS ReportSysnc Tool
By using this tool I was able to deploy reports to SSRS 2012 from SSRS 2005.


                       Advantage
                   Dis-Advantage
1. Very quick in migrating report
1. Does not deploy data source
2. Deploy subscriptions as well
2. Need to create Data source manually and re link reports to data source.
3. having source and destination side by side help in understanding synchronization
3. This makes it  time consuming approach.








2. Using  RSScripter - ExecSQL.org Tool
This tool really worked well and will definitely ease migration task.


                       Advantage
                   Dis-Advantage
1. Deploy reports and data source both
1. After migration shared data sources need to be re visited for inserting passwords, only if user id and password are hardcoded.
2. It has migrated report model as well. 
2. Subscription are not able to migrate. 
3. It script out all the ssrs code which needs to be than taken to migrated (new) server and need to deploy their using command prompt utility of SSRS.
3. Manual work of deploying SSRS script to migrated server is required with some minimum changes to script based on server details.
4. Working very smoothly and I have not faced any problem in deployment while migrating  couple of existing projects. 














3. Manual Migration process  -
This is an obvious approach, that we manually migrate all the reports.

                       Advantage
                   Dis-Advantage
1. Safest approach as one by one report will be taken and deployed and tested.
1. Very long, time consuming and tedious approach.
2. can fix issues and do enhancement if required while migrating.


No comments:

Post a Comment