Upgrading to SQL Server 2005
The following are some tips for upgrading to SQL Server 2005:• Upgrade to SQL Server 2005 from SQL Server 7.0 or SQL Server 2000.
• Run Upgrade Advisor before upgrading to determine if any product changes are expected to break existing applications.
• The SQL Server Database Engine, Analysis Services, and Reporting Services can be upgraded by the setup program.
• SQL Server Integration Services, the replacement for Data Transformation Services (DTS), is installed side by side with DTS. You can run DTS packages using the DTS runtime components.
• SQL Server 2005 Notification Services is installed side by side with Notification Services 2.0. You must migrate instances of Notification Services to SQL Server 2005 when you upgrade the SQL Server Database Engine.
• Use the Surface Area Configuration tool after upgrading to enable or disable SQL Server 2005 services, network protocols, and features.
Labels: 2005, DTS, microsoft, migration, SQL Server
0 Comments:
Post a Comment
<< Home