11.2. Conversion from SQL Server 2000
In this section we discuss issues around converting an existing SQL Server 2000 DW/BI system to SQL Server 2005. Some components, like the relational database, will convert smoothly. For other components, we recommend a more drastic approach.
11.2.1. Relational Data Warehouse
It should be quite straightforward to upgrade your relational data warehouse database from SQL Server 2000 to SQL Server 2005. Use the Copy Database Wizard to perform the upgrade, as described in Books Online. Note that indexes and constraints are automatically disabled during the upgrade process. You must manually re-enable them.
Although we're certainly not guaranteeing that an upgrade of your relational database to SQL Server 2005 will be trouble-free, we expect a minimum of problems and fuss.
After you've successfully upgraded the existing databases, consider whether to change the database's structure to take advantage of new features in the relational engine. For a relational data warehouse database, the most interesting new feature of the engine is partitioned tables, as we describe in Chapter 4. If you're using UNION ALL views to simulate partitioning in SQL Server 2000, you should convert the structures to partitioned tables. There is no wizard to do this for you, but the conversion should be straightforward. If you used SQL Server 2000 partitioned views you have already tackled the maintenance problem of creating new partitions every new time period. You will ...
Get The Microsoft® Data Warehouse Toolkit: With SQL Server™ 2005 and the Microsoft® Business Intelligence Toolset now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
