Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Microsoft SQL Server 2008 R2 Unleashed- P29:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 234 CHAPTER 9 Upgrading to SQL Server 2008 Note that the DTS Parameters screen advises that you must install the Legacy Components feature when installing SQL Server 2008 otherwise SQL Server 2008 will not be able to run your DTS packages unless they are upgraded to the new SSIS format . To upgrade your DTS packages you need to use the DTS Migration Wizard which is installed with SSIS and discussed later in this chapter in the section Migrating DTS Packages. When you re all set with your DTS and SSIS selections click Next to reach the Confirm Upgrade Advisor Settings screen. Make sure that all the SQL Server services you are analyzing are running and if you re happy with your selections click the Run button to begin the analysis. As you can see from the Upgrade Advisor Progress screen that appears see Figure 9.6 the wizard performs a task-based study of each component providing per-step reporting similar to the installer and the System Configuration Checker both discussed in Chapter 8 . FIGURE 9.6 The Upgrade Advisor Progress screen. When the analysis is complete the UA Progress screen presents a Launch Report button. The output of the UA Analysis Wizard is an XML report that you can view via the second major component of the UA the Report Viewer described in the next section. NOTE You can view your last-generated report by using the Report Viewer you can find the link to launch it on the main screen. If you run the UA more than once against the same SQL Server instance however you must save your previously generated reports to a directory other than the default output directory otherwise the previously generated report will be overwritten. Download from www.wowebook.com Using the SQL Server Upgrade Advisor 235 UA reports are saved by default to the folder My Documents SQL Server 2008 R2 Upgrade Advisor Reports Servernarne and then they are broken down into separate XML files by component for example AS.xml for Analysis Services DE.xml for the Database Engine . You
