Analysis Services 2000 repository

Last Post 28 Dec 2006 01:59 AM by SQLUSA. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
vassim2
New Member
New Member

--
27 Dec 2006 10:53 AM
Hi, we are upgrading SQL servers 2000 to 2005, but not Analyses Services yet. Can we store AS 2000 repository in SQL server 2005? Are they fully compatible, has it been tested?
Thank you
Marina
SQLUSA
New Member
New Member

--
28 Dec 2006 01:59 AM
When you run AS upgrade, it should take care of it.

Can you try it and let us know?

Kalman Toth DB, DW & BI Architect, SQL Server Training
URL: http://www.sqlusa.com/businessintelligence
The Best SQL Server 2005 Training in the World
JHunter
New Member
New Member

--
28 Dec 2006 04:53 AM
I think Marina was enquiring about still running AS 2000 but using SQL 2005 to host the repository database.

Given that the repository will run under Access, and SQL 2000, 2005 should have no problems - set the compatibility flag to 80.

Jamie
SQLUSA
New Member
New Member

--
13 Jan 2007 08:31 AM
See if this helpful from BOL5: Meta Data Services 3.0 is a component of Microsoft SQL Server 2000 that is no longer available in Microsoft SQL Server 2005. Upgrading does not delete the existing repository tables in the msdb database. However, the repository engine that reads and updates the tables is not available after you upgrade, and the repository tables are no longer accessible. To remove the unused tables, you can manually delete them. Repository tables can be identified by the Rtbl prefix.

Kalman Toth DB, DW & BI Architect, SQL Server Training
URL: http://www.sqlusa.com/businessintelligence
The Best SQL Server 2005 Training in the World
SQLUSSR
New Member
New Member

--
27 Jan 2007 03:44 PM
This may be helpful. Perhaps even more so than the information provided by SQLUSA!

www.SQL-USSR.Com/BestPractices/


Acceptable Use Policy
---