Moving Reports to SQL Server 2005

I have a new SQL Server running 2005. I have moved over all the user
application databases from a SQL Server 2000 server. I had a few reports
written in 2000. Do you move over the databases called ReportServer and
ReportServerTempDB from 2000 to 2005 or do you let the setup disk create the
new databases on the 2005 machine?
ThanksI assume you want to be using RS 2005? My suggestion is to install RS 2005
and let it create the databases. Next convert your reports to RS 2005 format
(open in the designer, it will convert, then save the change) and then
deploy to the new server. Note, I would save your rdl files somewhere before
converting them. I have found this sequence to be the best.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <Don@.discussions.microsoft.com> wrote in message
news:70AFFA98-B0D8-4438-86A9-DEFA786D6F04@.microsoft.com...
>I have a new SQL Server running 2005. I have moved over all the user
> application databases from a SQL Server 2000 server. I had a few reports
> written in 2000. Do you move over the databases called ReportServer and
> ReportServerTempDB from 2000 to 2005 or do you let the setup disk create
> the
> new databases on the 2005 machine?
> Thanks|||The best way is to upgrade them in visual studio 2005 or "sql server
business intelligence studio" on the server, and then deploy them to
the new server.
It is also a good time to revisit your reports
So in simple terms, one wouldn't copy the reporting services databases
if you have the rdl and rsd files on a file share somewhere so you can
upgrade and deploy them.
Regards,
Tom Bizannes
SQL Server Specialist
Sydney, Australia|||If you are upgrading from Reporting Services 2000 to Reporting Services
2005 the Reporting Services Configuration tool will happily upgrade your
old 2000 databases (including all your reports) to the new 2005 format.
Just make sure you backup your encryption key from the SRS 2000 instance
first.
Follow the instructions here:
http://msdn2.microsoft.com/en-us/library/aa972238(SQL.80).aspx
Also make sure you upgrade your 2000 SRS databases using an SQL 2005 RTM
(no service packs applied) version of SQL Server. There is an issue in SP2
when upgrading a 2000 database that you might run into.
1. After you've backed up the key open the SRS 2005 Configuration Tool and
go to the "Database Setup" section.
2. Select the database server you are connecting to that has your old
ReportServer and ReportServerTempDB and click "Connect"
3. Then select "ReportServer" in the database dropdown.
4. Then either click "Apply" or "Upgrade" either one should ask you to
upgrade the database.
5. After that is done you'll probably need to apply the key you backed up
earlier.
6. Go to the "Encryption Keys" section and click "Restore" and follow the
prompts.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.