توضیح :
موضوع : کتاب آموزش برنامه نویسی SQL2005 زبان اصلی
Each Microsoft SQL Server 2005 component is designed
to have a unique architecture and life cycle—the two
primary areas that can affect an upgrade path. Some SQL
architecturecomponents build on a solid foundation to
augment, optimize, and help stabilize existing functionality.
Microsoft has performed an extensive reworking
of other SQL Server features to enhance performance
and application programmability. SQL Server 2005 also
incorporates completely overhauled components and
additions designed to meet a new generation of datamanagement
needs.
Preparing for a SQL Server 2005 upgrade involves
understanding some basic principles that enable administrators
to make appropriate decisions and help ensure
success. As with any upgrade, the keys to success are
appropriate planning and testing for the needs of the
specific environment. This article explores the overall
upgrade path for SQL Server 2005 components and how
the SQL Server 2005 Upgrade Advisor tool can help
identify areas that require special attention. Specific
upgrade considerations for certain SQL Server 2005
components—the database engine, Integration Services,
Analysis Services, and Reporting Services—are
also examined.
Upgrade mechanism
For all components, SQL Server 2005 provides an
upgrade from SQL Server 2000 or SQL Server 7.0. Note
that Microsoft distinguishes between a SQL Server 2005
upgrade and a migration.
An upgrade is an automated process in which the
upgrade tool, called Setup, moves an old instance of
SQL Server to a new instance while maintaining the
data and metadata of the old instance. At the end of