Large Analysis Database Migration

The aim of this report is to share lessons learned when migrating a large SQL Server Analysis Database with hundreds of gigabytes in size, with hundreds of users, and thousands of user queries from version 2000 to 2005.

It describes how:
- MDX syntax and design of the analytical database changed
- ProClarity repository with user queries was updated
- Analytical Processing was designed
- Utilities were useful in the migration process

Read more...