SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Urgent - Reporting services migration and upgrade to 2008 R2


Urgent - Reporting services migration and upgrade to 2008 R2

Author
Message
Nikita-395727
Nikita-395727
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 168
Hello,

We have a task to move reporting services 2005 instance to new servers with 2008 R2 version.


This is what I did so far:

1. Since web and database servers are different, I first installed sql server on database server.
2. Installed reporting services on web server.
3. Restored ReportServer and ReportserverTempdb to the new 2008 R2 database server.
4. Configured reporting services and selected resored reportserver and reportservertempdb on the new server.

I can access the URLs and reports now.

This is my first time touching reporting services. Our reporting services guy in the team is gone and we have a very tight deadline to deliver test, stage and prod environments in next 3 weeks.

We have over 250 reports. From the collected info, I believe that there is no custom configuration.

Our Development team has given us estimate of 2 manual months offshore and 80 hours onsite to convert all reports to 2008 R2. First of all, we don't have that kind of time and second, I am trying to find out what is left to do now and whether it is worth paying so much money to development.

I searched the forums and articles but I am not clear on when to conclude that the migration is done. Do I need to open every report in BIDs and save it in order to upgrade it? If yes, is there any script or utility availabel to do that?

Thanks,
Nikita
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10143 Visits: 6367
Do you have the solution files to hand?

If so make a backup of them in their 2005 state, then open the originals in BIDS 2008, it should run you through the upgrade process.

Obviously if there is any errors they will need fixing but if not, then you can simply just redeploy the solution to the 2008 reporting server.

Also take a look for a tool called RSScriptor if you don't have the solution files, it will pull the RDL files from 2005 and then you can open them upgrade them in BIDS 2008.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Nikita-395727
Nikita-395727
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 168
Anthony,

Pardon my ignorance.

First approach I thought of using RSSscripter but the following link does not work:
http://www.sqldbatips.com/showarticle.asp?ID=62

From what I understand, you do not need to backup-restore dbs with that to new location. I have already done it.

If you could tell how to generate solutions files, I can work on it myself to save time.

Thanks
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10143 Visits: 6367
You need to backup the solution files not to backup the databases, so that you have the solution in a 2005 format as once you have upgraded them you cannot downgrade, its to ensure that you still have the originals.

RSScriptor is used to pull the RDL files from the reporting server, you then create a new solution in BIDS and then add in the RDL files which RSScriptior has saved for you in the location you told it to save them.

I have attached a copy of the tool.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Attachments
RSScripter.rar (11 views, 242.00 KB)
Nikita-395727
Nikita-395727
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 168
Thanks for the scriter tool.

I will check out the scripting options.

Thanks,
Nikita
EdVassie
EdVassie
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5850 Visits: 3866
You say you have restored the SQL 2005 ReportServer db and ReportServerTempdb to your SQL 2008 R2 system and are using those with the SQL 2008 R2 binaries.

If so, I do not think you have a system that will be supportable by Microsoft. You need to use the SQL 2008 R2 report server databases with SQL 2008 R2.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search