Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2000 Analysis Services cubes with SQL Server 2005 databases


SQL 2000 Analysis Services cubes with SQL Server 2005 databases

Author
Message
Hema Mutreja
Hema Mutreja
Mr or Mrs. 500
Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)

Group: General Forum Members
Points: 547 Visits: 322
Hi,

We are planning to migrate few of our SQL Server 2000 databases to SQL server 2005.
These databases also have some Analysis Services cubes, which we do not plan to migrate as of now.

Are there compatability or any other known issues with running SQL Server 2000 Analysis Services cubes with SQL Server 2005 databases.

Thanks
Hema
denglishbi
denglishbi
SSChasing Mays
SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)SSChasing Mays (639 reputation)

Group: General Forum Members
Points: 639 Visits: 1362
You should be fine since you are just moving the data and keeping the SSAS database 'as-is'. The real benefit would be to move the SSAS database to 2005 since there were major improvements made with the UDM, BIDS, design, MDX, memory, etc.

I would test the connectivity to see if you might need to install an updated client on the server which you could download from the SQL Server 2005 Feature Pack if needed.

Here is a good posting on SSAS upgrade to 2005:

Steps to a Seamless Migration of SSAS 2000 to 2005 Database

Just remember that SQL 2000 is no longer supported. You can utilize the Upgrade Advisor which is part of the Feature Pack also to do some preliminary analysis of your 2000 components to prep for the migration. SP1 for SQL Server 2008 has been released now also, so you might want to look at the potential to skip directly to 2008 also.

Here is a great reference guide in regards to upgrading:

SQL Server 2008 Upgrade Technical Reference Guide - This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search