August 9, 2005 at 7:25 am
Hi,How to rename a database mantaining the data in the cubes?Thanks in advance.
PS: Originally posted in http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.olap.
August 9, 2005 at 7:31 am
Can't you use sp_renamedb for this?
August 9, 2005 at 7:44 am
I need to rename the database in Analysis Services, not SQL Server.
August 9, 2005 at 7:47 am
Sorry, no clue in that case.
August 9, 2005 at 6:04 pm
If you want to rename just the catalog/DB, can't you copy and paste to the same server and it will prompt you for a new (different) name?
If you want to rename the datasource name, then you really need to add this to your dev best practises -> Create new catalog, create datasource, copy and paste datasource with new (nice) name, delete original datasource, start working on cubes/dims etc.
Steve.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply