How to move SQL Server 2005 SSRS to SQL Server 2008 SSRS

• gary1

  SSC-Insane

  Points: 21152

  More actions

  October 13, 2010 at 12:56 pm

  #225026

  Hi,

  We have SQL Server 2005 SP1 EE edition 32 bit reporting Services and Database Engine on same Windows 2003 32 bit Server and we 120 reports and an ORACLE data source.

  Now we have build a new Windows 2008 64 Server and installed SQL Server 2008 R2 RTM EE 64 bit Database Engine and Reporting Services (Install BUt Do not Configure Option)

  Now what is the Process to Migrate the ReportServer & ReportServerTempDB databases and all 120 reports?

  Thanks for your inputs

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  October 13, 2010 at 1:07 pm

  #1236461

  Hi

  Find the below sites which might give u some idea

  http://www.sqlservercentral.com/Forums/Topic664428-162-2.aspx%5B/url%5D

  [url] http://msdn.microsoft.com/en-us/library/ms143724.aspx%5B/url%5D

  [url]

  http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/0d4af4e9-99e9-433c-b1c5-decf74198678"> http://www.sqlservercentral.com/Forums/Topic664428-162-2.aspx%5B/url%5D

  http://msdn.microsoft.com/en-us/library/ms143724.aspx%5B/url%5D

  http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/0d4af4e9-99e9-433c-b1c5-decf74198678

  Thanks

  Parthi

  Thanks
  Parthi