
17
Migrating to a Dell PowerEdge R515 server from two legacy database servers
Once you have installed the SQL Server 2008 R2 Upgrade Advisor, you
can use this software to scan your SQL Server 2000 and SQL Server
2005 instances for potential migration issues. This section provides a
brief walkthrough; Appendix F gives more detailed instructions.
4. Select StartAll ProgramsMicrosoft SQL Server 2008 R2SQL
Server 2008 R2 Upgrade Advisor.
5. Click the Launch Upgrade Advisor Analysis Wizard link, and click
Next to begin.
6. Enter the older SQL Server computer name, and select the
features you want the Upgrade Advisor to analyze. Alternatively,
click Detect to have the Upgrade Advisor remotely scan the older
SQL Server machine and detect which components are running on
the server. (See Figure 6.)
Figure 6. Upgrade Advisor component selection.
7. Choose your instance, provide proper authentication to the older
SQL Server, and select the database you want to analyze. If
necessary, you can also input SQL script files and trace files here.
8. You may have legacy Data Transformation Services (DTS) packages
on SQL Server 2000 servers. 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
Kommentare zu diesen Handbüchern