Is it recommended to use the utility with AS 2005 to convert or just rebuild
in 2005?

Are there any documented pro's and con's from either approach?

Thanks for your help.

Anyone have any ideas? Has anyone done this?

"Ublguy" wrote:

Unless the AS 2000 database is quite simple, it may be better to
redesign it in AS 2005. The Migration Wizard could still be useful in
providing a starting point or reference for the redesign. There are some
TechNet resources which discuss migration to AS 2005, such as:

http://www.microsoft.com/technet/pro.../asmigrtn.mspx
Published: August 19, 2005
By Michael Young, Proclarity Corporation, and Dave Wickert, Microsoft
Corporation

SQL Server Technical Article
Applies To: SQL Server 2005

Summary: This paper guides you through the process of migrating to
Analysis Services in SQL Server 2005. The Unified Dimensional Model
(UDM) provides new design opportunities for cube developers. The UDM has
brought together the relational reporting and OLAP reporting worlds to
provide a unified forum for both data request environments.
Understanding the new design options and how they affect your
organization will optimize migration. The Migration Wizard is a fast and
effective tool for moving your existing cubes to Analysis Services 2005.
This paper introduces the wizard and helps you determine whether you
should use it. In some cases it is better to redesign from scratch to
ensure that you are properly leveraging the new features of Analysis
Services 2005.
...

http://www.microsoft.com/events/Even...ource=MSCOMMed
ia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22 ID%22+Value%3d%2210322
85766%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value %3d%22A6B43178-497C-42
25-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Valu e%3d%22en%22%2
f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e% 7esParams%5e%7e%2fsPar
ams%5e%7e%2fCMTYDataSvcParams%5e

Migrating from Microsoft SQL Server 2000 to SQL Server 2005 could be a
daunting task. If you face this challenge, you will want to join this
webcast to learn about the options available for migrating SQL Server
2000 Analysis Services solutions to SQL Server 2005. We explain the
trade-offs involved to help you make better-informed decisions for your
own implementation. We also summarize the known issues with backward
compatibility and suggest some strategies that you might use to mitigate
potential issues in your own implementation.

Presenters: Thierry D'Hers, Program Manager Lead, SQL Server, Microsoft
Corporation, and T.K. Anand, Program Manager, SQL Server, Microsoft
Corporation
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***