Author: Alexei Khalyako
Contributors: Dmitry Artemov, Sergey Pyrin
Technical Reviewers: Vijay Tandra Sistla, Mike Weiner, Mark Souza
Editor: Beth Inghram
Summary
In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:
- Install all SQL Server instances on the Windows Server® 2003 x64 platform.
- Upgrade the publisher and distributor from the 32-bit edition of SQL Server 2000 to the 64-bit edition of SQL Server 2008. (Upgrading subscribers was not a goal of this phase of the project.)
- Avoid replication re-initialization.
This paper describes how to upgrade replication members such as Publishers and Distributors from the 32-bit edition of SQL Server 2000 to the 64-bit edition of SQL Server 2008. Both clustered and nonclustered environments are discussed.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
