16
Migrating to a Dell PowerEdge R515 server from two legacy database servers
WE SHOW YOU HOW: MAKING THE MOVE
Upgrade Advisor makes it easy
The SQL Server 2008 R2 Upgrade Advisor is a major aid in migration
research. This utility, which the SQL Server 2008 R2 setup wizard
includes, scans legacy databases and SQL Server components for
compatibility issues, features, and syntax the newer DBMS does not
support, as well as many other critical components. The utility lets
you view reports quickly in the Upgrade Advisor interface or save
reports for later review.
You can install and execute the Upgrade Advisor on machines running
Windows XP SP2 or greater, Windows Vista
®
SP1, Windows 7,
Windows Server 2003 SP2, Windows Server 2008 SP2, or Windows
Server 2008 R2. The Microsoft .NET
TM
framework is also a
requirement.
BEST PRACTICE: Use the Upgrade Advisor tool on your SQL Server
2000 and SQL Server 2005 databases and import a trace file to the
Upgrade Advisor tool for analysis. The trace file lets the Upgrade
Advisor detect issues that might not show up in a simple scan of the
database, such as TSQL embedded in applications. Your migration
research and planning must account for such instances. You can
capture traces of TSQL using SQL Server Profiler on your SQL Server
2000 and SQL Server 2005 servers during typical hours and analyze
these traces using the Upgrade Advisor.
To install the Upgrade Advisor, use the following steps:
1. Insert the SQL Server 2008 R2 DVD. Click the Planning link, and
click Install SQL Server Upgrade Advisor.
2. Click Next to begin the installation wizard, accept the licensing
terms, and click Next.
3. Click Next to accept the default Registration information, click
Next to accept the default installation path, and click Next to
begin the installation.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales