August 10, 2011 at 2:56 pm
I am a recent hire and came into a SQL 2005 reporting services environment. We now have a SQL Server 2008 Reporting environment and I need to move all of the reports over to the new server. I was able to pull down the .rdl files from the 2005 server for the reports, but how can I copy over the shared data sources? I can't find any .rsd files on the 2005 server, but I can see the shared data sources through the web-based ReportsServer. And of course, our old DBA left me with no documentation or source files of any kind. =(
The old reports work, so the data sources must be somewhere, I just can't find them!
Thank you.
August 10, 2011 at 3:23 pm
In SQL 2008 they are located in ReportServer.dbo.DataSource
Here is a pretty thorough guide to migrating from 2005 to 2008.
August 10, 2011 at 3:57 pm
I read through the guide, it doesn't contain any information on migrating shared data sources, only information to migrate an entire reporting services installation, which I dont want to do because I already have CRM2011 on the new server and all the reports that come with it.
in SQL 2005, the dbo.DataSource table does exists and looks to contain data sources, but it looks to be just references to other tables. I don't think copying these rows from the 2005 DB to the 2008 DB will do the trick.
Any other help would be greatly appreciated. And thank you for your help so far, that article was informative.
August 10, 2011 at 4:15 pm
This tool has come in handy for me a few times moving between 2005 SSRS servers. I don't recall using it to move from 2005 to 2008.
http://www.sqldbatips.com/showarticle.asp?ID=62
jg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply