Visitors Edition
Membership Help?
Need help? Our Trial Membership program will get you help on any IT project you're working on. You'll get access to our research, tools, advice and project help.
Start your free trial membership now:
Start your free trial membership now:
Want to learn more about our membership options, pricing, or to get a product demo?
Get in touch with one of our reps using an option below.
Learn more About Info-Tech
Upgrade to Microsoft SQL Server 2008 R2
SQL 2008 R2 is largely unchanged from SQL 2008 but has a major upside for those looking to secure Business Intelligence.
More Details
Your Challenge
- Organizations running an SQL database rely heavily on it to function properly for business continuity purposes – an upgrade can be costly if it results in major downtime and significant application rework.
- Upgrading a database can be done two different ways and is highly dependent on the versions, components, and applications the organization runs.
- The offering provided in 2008 R2 is very similar to that of 2008, but significant benefits do exist for organizations that fit into certain groups – understand where you stand, then assess and decide accordingly.
Our Advice
Critical Insight- SQL 2008 R2 drastically improves the Business Intelligence offering of SQL Server 2008. Organizations that require BI functionality but lack the budget to implement third-party tools should seriously consider upgrading.
- Application testing and creating an upgrade process are where the majority of IT pros spent effort throughout the planning phase of the upgrade, regardless of what version of SQL they were moving from.
- Licensing has become more expensive in comparison to the schema available under SQL Server 2008 – organizations that wish to continue using the unlimited licensing setup of SQL 2008 should stay with their current setup, or move to SQL Server 2008 R2 Datacenter Edition at $57,498.
- Involve executives and employees throughout the project to effectively communicate strategies and solicit cooperation.
- Thoroughly test business critical apps before upgrading, to ensure minimal downtime and post-upgrade rework.
- Use Microsoft’s provided tools, such as the Microsoft Assessment and Planning Toolkit and Upgrade Advisor, to get the organization through the upgrade process with minimal hiccups.
Get to Action
-
Put together a steering committee and dedicated upgrade team.
Build a business case for the upgrade and achieve executive buy-in.
-
Log issues and resolutions with the upgrade.
Ensure the upgrade goes smoothly, and that future upgrades go forward with less issues.
-
Consider upgrading the SQL database.
Yield BI savings and leverage the Software Assurance agreement.
Related Solution Sets
Assess Oracle's Role in the Enterprise Database Strategy
Oracle Database is expensive. Get rid of it if you can, or make the most of it if you can't.
Get the Complete Storyboard
See how all the steps you need to take come together, with tools and advice to help with each task on your list.
BONUS: Get access to up to 5 additional free downloads
Download NowSolution Road Map
Other Solution Sets in Enterprise Databases
1. Upgrade to Microsoft SQL Server 2008 R2
SQL 2008 R2 is largely unchanged from SQL 2008 but has a major upside for those looking to secure Business Intelligence.
SQL 2008 R2 is largely unchanged from SQL 2008 but has a major upside for those looking to secure Business Intelligence.
2. Assess Oracle's Role in the Enterprise Database Strategy
Oracle Database is expensive. Get rid of it if you can, or make the most of it if you can't.
Oracle Database is expensive. Get rid of it if you can, or make the most of it if you can't.
