447
SQL Server 2012 Upgrade Technical Guide
Appendix 1: Version and Edition Upgrade
Paths
Table 1, taken from
Supported Version and Edition Upgrades
(http://msdn.microsoft.com/en-us/library/ms143393(v=sql.110).aspx) in SQL Server
2012 Books Online, shows the paths that SQL Server 12 Setup will allow when directly
upgrading a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 instance by
using the in-place upgrade method.
Table 1: Supported Paths for an In-Place Upgrade to SQL Server 2012 from SQL Server
2005, SQL Server 2008, or SQL Server 2008 R2
Upgrade From
Supported Upgrade Path
SQL Server 2005 SP4 Enterprise
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
SQL Server 2005 SP4 Developer
Microsoft SQL Server 2012 Developer
SQL Server 2005 SP4 Standard
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
SQL Server 2005 SP4 Workgroup
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
SQL Server 2005 SP4 Express,
SQL Server 2005 SP4 Express with Tools, and
SQL Server 2005 SP4 Express with Advanced Services
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
Microsoft SQL Server 2012 Express
SQL Server 2008 SP2 Enterprise
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
SQL Server 2008 SP2 Developer
Microsoft SQL Server 2012 Developer
448
SQL Server 2012 Upgrade Technical Guide
Upgrade From
Supported Upgrade Path
SQL Server 2008 SP2 Standard
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
SQL Server 2008 SP2 Web
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
SQL Server 2008 SP2 Workgroup
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
SQL Server 2008 SP2 Express,
SQL Server 2008 SP2 Express with Tools, and
SQL Server 2008 SP2 Express with Advanced Services
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
Microsoft SQL Server 2012 Express
SQL Server 2008 R2 SP1 Datacenter
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
SQL Server 2008 R2 SP1 Enterprise
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
SQL Server 2008 R2 SP1 Developer
Microsoft SQL Server 2012 Developer
SQL Server 2008 R2 SP1 Standard
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
SQL Server 2008 R2 SP1 Web
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
SQL Server 2008 R2 SP1 Workgroup
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
449
SQL Server 2012 Upgrade Technical Guide
Upgrade From
Supported Upgrade Path
SQL Server 2008 R2 SP1 Express,
SQL Server 2008 R2 SP1 Express with Tools, and
SQL Server 2008 R2 SP1 Express with Advanced
Services
Microsoft SQL Server 2012 Enterprise
Microsoft SQL Server 2012 Business Intelligence
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
Microsoft SQL Server 2012 Express
450
SQL Server 2012 Upgrade Technical Guide
Appendix 2: SQL Server 2012: Upgrade
Planning Checklist
Decision
Factors
Notes
Preparing to Upgrade
Decide to upgrade to
SQL Server 2012
Identify the business reasons for upgrading
to SQL Server 2012.
Choose SQL Server 2012
enhancements to
implement
Select required and desired SQL Server
2012 features and enhancements for
current and future development in the
following categories:
Relational Database Features
Database Engine
AlwaysOn
Security and auditing
Business Intelligence Features
Analysis Services
Data mining
Integration Services
Reporting Services
Determine instances of
SQL Server to upgrade
Classify upgradable instances of SQL Server
according to level of criticality:
High level (mission critical)
Medium level
Low level
Also classify according to whether
instances are:
Default instance
Named instance
Virtual machine (VM)
Backward compatibility
and upgrade tools
Gain familiarity with and select the
appropriate upgrade tools for use in
upgrade planning:
SQL Server 2012 Upgrade Advisor
Microsoft MAP Toolkit 6.5
Upgrade Assistant for SQL Server
2012 (UAFS)
Best Practices Analyzer for SQL
Server 2005, 2008, or 2008 R2
SQL Server Profiler
451
SQL Server 2012 Upgrade Technical Guide
Decision
Factors
Notes
Ensure that servers meet
SQL Server 2012
requirements
Ensure that servers meet minimum
requirements for SQL Server 2012,
including:
Sufficient processor, memory, and
free disk space
Windows Server 2008 R2 SP1 or
later
SQL Server 2005 SP4 or later (in-
place upgrade)
SQL Server 2008 SP2 or later
SQL Server 2008 R2 SP1 or later
Decide on CPU platform:
64-bit or 32-bit
Determine what CPU platform to use for
SQL Server servers, and ensure that
database servers meet requirements.
Determine upgrade
paths for editions
For each server, determine the proper SQL
Server 2012 edition to upgrade to:
Enterprise
Business Intelligence
Standard
Express
Ensure that the legacy instances of SQL
Server will have allowed upgrade paths for
in-place upgrades.
Determine application
connectivity
requirements
Determine whether applications require
any of the following:
Upgrade to support SQL Server
2012
Changes to connectivity settings
Changes to authentication mode
Measures to prevent SQL Injection
Determine Windows
upgrades
For each database server, determine
whether it requires a Windows upgrade.
Note the restrictions on Windows Server
versions for SQL Server:
SQL Server 2012 requires Windows
Server 2008 R2 SP1 or later
Only SQL Server 2005 SP3 or later is
supported on Windows Server 2008
R2
Select the appropriate
upgrade strategy
For each server or database, choose the
optimal upgrade strategy:
In-place upgrade
Side-by-side upgrade
Same physical server or VM
Separate physical server or VM
452
SQL Server 2012 Upgrade Technical Guide
Decision
Factors
Notes
Developing an Upgrade Plan
Upgrade as an IT project
Follow standard IT project practices for
developing the upgrade project. Identify:
Team members
Stakeholders
Application/business owners
Follow standard IT project procedures for
the upgrade.
Update DBA skills to SQL
Server 2012
Ensure that DBA team members have SQL
Server 2012 skills for implementing and
potentially troubleshooting the upgrade.
Document the upgrade
plan
Ensure that critical decisions and steps are
documented and known to those involved
in the upgrade.
Include other upgrade
knowledge
Gather and consider lessons from past
upgrades.
Minimize upgrade
variables
Keep the project focused as much as
possible on upgrading.
Avoid extending the project scope to
application enhancements or fixes not
related to upgrading.
Identify pre-upgrade
tasks
Identify tasks that might be accomplished
before the upgrade and without downtime.
For example, determine where it is possible
to pre-install or enable .NET Framework 3.5
SP1.
Establish performance
baselines
Use tools such as SQL Server Profiler to
gather data indicating typical performance
measurements.
Ensure that the broadest possible sets of
commands are captured in traces.
Estimate required
downtime
Allow sufficient downtime so that the
upgrade process and testing can be
completed successfully.
Allow time for rollback if unexpected issues
arise.
Develop upgrade
checklists
Detail the steps required for taking the
systems offline for a period of time and
bringing them back online.
Detail the steps to take during the upgrade
processes.
Develop an upgrade test
plan
Build a test environment.
Determine test procedures for each
individual upgrade or upgrade type.
Test the upgrade checklists and procedures
and revise as results indicate.
Be familiar with upgrade troubleshooting
techniques.
453
SQL Server 2012 Upgrade Technical Guide
Decision
Factors
Notes
Identify backup and
restore operations
Plan for backing up the targeted legacy
databases.
Verify the backups.
Plan for restoring the backup files if
needed.
Test all backup procedures.
Determine acceptance
and rollback steps
Identify how the organization will accept
the upgrade, and how it will make the
"go/no-go" decision:
Verify tests to ensure applications
using the upgraded database
servers will run as expected and
required.
If available, enlist the support of
the quality assurance (QA) team to
develop appropriate acceptance
tests.
Determine exactly when and how a
rollback to the legacy SQL Server
might be required.
Test the rollback plan.
Post-Upgrade Tasks
Integrate the upgraded
server
Remaining tasks might include the
following:
Update statistics
Rebuild cubes
Reconfigure log shipping
Reconfigure database mirroring
Test a failover cluster
Verify that SQL Server Agent jobs
run correctly
Decommission servers
After a suitable time period, after full
acceptance of upgrades, decommission
servers that are no longer needed for
rollback or running in parallel.
Prepare for the next
upgrade
Collect knowledge and experience from the
upgrade project and store it so that lessons
learned can be used in future upgrade
projects.
454
SQL Server 2012 Upgrade Technical Guide
Did this paper help you? Please give us your feedback. Tell us on a scale of 1 (poor) to
5 (excellent), how would you rate this paper and why have you given it this rating? For
example:
Are you rating it high because of having good examples, excellent screenshots,
clear writing, or another reason?
Are you rating it low because of poor examples, fuzzy screenshots, or unclear
writing?
This feedback will help us improve the quality of white papers we release.
Send feedback
.
Dostları ilə paylaş: |