migration from sql 2008 report services to sql 2008 r2 report services
ALL,
I have sql report services(2008) and report databases on same machine which is 32 bit
i want to migrate sql report services and report databases to sql 2008 r2( which is 64 bit machine)...
Can you guys suggest me any document or link to migrate ssrs from one server to another server
TIA
January 12th, 2011 10:38pm
Hi Kashif412,
As we know report definitions are stored at report server database, so I recommend to use Backing Up and Restoring the Report Server Databases. See
http://technet.microsoft.com/en-us/library/ms156421(SQL.90).aspx for more details about Moving a Report Server Database to Another Computer. Also, check
http://msdn.microsoft.com/en-us/library/ms143724(v=SQL.100).aspx for other things you need to do.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 9:10pm