Side-by-side migration – Dell R810 User Manual
Page 21
Servers: Database consolidation on Dell PowerEdge R810 servers
21
Provide proper authentication to SQL Server 2000,
and select the database you want to analyze. If
necessary, you can also input SQL script files and
trace files here.
You may have legacy Data Transformation Services
(DTS) packages on the SQL Server 2000 server.
The DTS packages may be present in the file
system or in the database itself. If you selected
DTS, or if the Upgrade Advisor automatically
detected the presence of DTS packages, you
must now select the DTS location you want to
analyze. Click Run to start the analysis. Run
times vary.
Following the analysis of your SQL Server 2000
server, you can view the Upgrade Advisor report,
which lists warnings and errors. (See Figure 9.)
Figure 9. Sample Upgrade Advisor output report.
Side-by-side migration
In this section, we provide an overview of the processes involved in
migrating your database from SQL Server 2000 to SQL Server
2008 R2 on the Dell PowerEdge R810. We provide detailed
instructions in