Migrating Reporting Services Report to SQL Reporting Services 2012 in Native Mode


How to Migrating Reporting Services Report to SQL Reporting Services 2012 in Native Mode



The migration process for Reporting Services includes manual and automated steps. The following tasks are part of a report server migration:
  • Back up database, application, and configuration files.
  • Back up the encryption key.
  • Install a new instance of SQL Server 2012. If you are using the same hardware, you can install SQL Server 2012 side-by-side your existing SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 installation. Be aware that if you do this, you might need to install SQL Server 2012 as a named instance.
  • Move the report server database and other application files from your existing installation to your new SQL Server 2012 installation.
  • Move any custom application files to the new installation.
  • Configure the report server.
  • Edit RSReportServer.config to include any custom settings from your previous installation.
  • Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group.
  • Test your installation.
  • Remove unused applications and tools after you have confirmed that the new instance is fully operational.

Different Techniques which can be used as below:


Approach 1 - Use RSS Scripter

You can download tool from below link

Although there are some limitations with things like shared datasets as they didn't exist when rsscripter was created. 

Approach 2 - Use Powershell:

Use Powershell by coding your own utility using rs.exe


Approach3 - Create your own using rs.exe 
And here is another great post and sample code to use rs.exe to deploy all sorts of RS type objects.


Approach 4: Deploy all SSRS reports using SQL Server Data Tools


Other useful links for Migrating to SQL 2012 Reporting Services in Native Mode as below:




Comments

Post a Comment

Popular posts from this blog

Calculating Age of the person in T-SQL

One of common calculations, we have to do in ETL is calculating age of the person from the date attribute And this is how I have calculated Age of the person. Select BirthDate , CASE             WHEN Month ( GetDate ()) < Month ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             WHEN Month ( GetDate ()) = Month ( c . [BirthDate] )             AND Day ( GetDate ()) < Day ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             ELSE DateDiff ( yy , c . [BirthDate] , GetDate ())         END AS [Age]               from [dbo] . [DimCustomer] c               order by BirthDate I am sure, there would be other better ways to do this and would love to hear, of how you have calculated age of the person
Read more

How to Troubleshoot Subscription issue in Reporting Services

Tips on troubleshooting Subscription issue in Reporting Services 1 – Look at the Reporting Services Log File Error Message from Log File: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   INFO: Notification 20f7b482-eb74-4b51-9e53-9f0609034e72 completed.  Success: False, Status: Failure writing file Startup :  The report server has encountered a configuration error. , DeliveryExtension: Report Server FileShare, Report: Startup, .......      2 - Run below query against ReportServer Database and this 
Read more

MDX Queries - Current Day - Month and Year

Problem: Query to get Current Day - Month and Year in MDX /* MDX for retrieving current Year */ WITH MEMBER [Measures].[Current Year] AS     VBAMDX. Format (VBAMDX.Now(), "yyyy" ) SELECT   {[Measures].[Current Year]} ON COLUMNS FROM [Analysis Services Tutorial]; /* Current Month */ WITH MEMBER [Measures].[Current Month] AS     VBAMDX. Format (VBAMDX.Now(), "MM" ) SELECT   {[Measures].[Current Month]} ON COLUMNS FROM [Analysis Services Tutorial]; /* MDX for retrieving current Date */ WITH MEMBER [Measures].[Current Date] AS     VBAMDX. Format (VBAMDX.Now(), "dd" ) SELECT   {[Measures].[Current Date]} ON COLUMNS FROM [Analysis Services Tutorial];
Read more