January 18, 2011 at 12:28 pm
Hi,
We are upgrading from SQL Server 2005 (SP3) to SQL Server 2008 R2.
I did the following:
1. Ran the SQL Server Upgrade Advisor and took care of the issues.
2. Moved the Logins from SQL Server 2005 to SQL Server 2008 Server.
3. Backed up the databases from SQL Server 2005 and restored them to SQL Server 2008.
So far so good...
My questions:
1. We have SQL Server 2005 (SSRS) reports on SQL Server 2005. Should I open these reports in BIDS 2005 or BIDS 2008 in order to apply them ontu the SQL Server 2008 R2 Server?
2. We have SQL Server Integration Packages (SSIS) in SQL Server 2005. Should I open these packages in BIDS 2005 or BIDS 2008 in order to apply them ontu the SQL Server 2008 R2 Server?
3. I understand that SQL Server 2008 R2 SSRS does not use IIS. So how does one configure IIS on SQL Server 2008?
Any help, tips or pointers appreciated.
Thanks
January 18, 2011 at 12:33 pm
I'm not sure if anyone else has a better solution.
When I did this I used RSScripter ( http://www.sqldbatips.com/showarticle.asp?ID=62 ). I was able to script out the objects from the SQL Server 2005 report server and import them into the SQL Server 2008 R2 server. I believe I may had to manually adjust some of the xml for the models because of spaces at the end of the xml that 2008 R2 did not like.
January 18, 2011 at 2:19 pm
This link has a great whitepaper about that migration. It can help you.
http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply