Search code examples
sqldatabasesql-server-2008ssas

changing the ID of an SSAS database

I want to rename my SALES cube to SALES_2009 and put a new cube called SALES. When I rename it, the ID remains as SALES so my new cube now is called SALES, but it's internal ID is SALES_2010 (and my old cube is called SALES_2009, but the internal ID is SALES).

Can the ID of a SSAS database be changed?

I have tried the properties window and googled bing, but to no avail.

Solution

  • You could backup and restore with new name - http://richardlees.blogspot.com/2009/05/new-analysis-services-database-version.html but there isn't any way to alter the databaseid AFAIK