| Author |
Topic |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2008-10-03 : 15:24:52
|
| I have a SQL 2000 Server that is the backend database server for a Reporting Services 2000 instance running on a different server.I need to replace the backend SQL 2000 database server with a new server. Is it possible to move the reporting services databases to a SQL Server 2005 datbase server without upgrading Reporting Services to 2005?Anyone got any links on this subject?CODO ERGO SUM |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 15:54:37
|
| You can use this to migrate:http://msdn.microsoft.com/en-us/library/ms156421.aspx |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-03 : 17:27:50
|
| I have seen a number of links like that for how to move Reporting Services databases from one server to another, but none says specifically that Reporting Services 2000 databases can be hosted on a 2005 database server.CODO ERGO SUM |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 17:37:08
|
| Why you don't want to upgrade it to 2005 for ReportServer database?Look at this:http://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-03 : 17:47:24
|
quote:
Originally posted by sodeep
Why you don't want to upgrade it to 2005 for ReportServer database?Look at this:http://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
I just need to replace the database server hardware, but would like to install SQL Server 2005 for the database server if it will work with 2000 Reporting Services.If I upgrade Reporting Services to 2005, that will involve testing all the reports to make sure it still works and getting a lot of people involved to do the testing.The link you posted explains how to host a Reporting Services 2005 database on SQL Server 2000, kind of the opposite of what I want to do.CODO ERGO SUM |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-06 : 13:45:27
|
quote:
Originally posted by Peso
Is this helpful?http://www.sqljunkies.com/WebLog/roman/archive/2005/11/03/17287.aspx
E 12°55'05.63"N 56°04'39.26"
That link seems to be for the situation where you are running Reporting Services 2000 and 2005 on the same server.My situation is different. I have SQL Server 2000 Reporting Services installed on a machine by itself (where it will stay) and am using a separate SQL Server 2000 database server for the backend database server. I need to replace the database server only, and am wondering if I can just restore the databases onto a SQL Server 2005 database server and have everything work OK.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-06 : 15:05:02
|
| I could test it, but I am reluctant to try it without some "official" blessing that MS will support the configuration.CODO ERGO SUM |
|
|
|
|
Reporting Services 2000 Databases on SQL 2005?