Hi,

How to rename a database mantaining the data in the cubes?

Thanks in advance.

With SQL2K, the only way is to copy and paste the database (using AM). On
the paste operation, the system will notice that the database aleady exists
and prompt you for a new name. After the paste succeeds you can then full
reprocess.

A similar activity with SQL2K5 would be to script out the database
definition (just right-click on SSMS and select "Script -> Create", then
edit the XMLA file to be a different database, hit Execute, and then full
reprocess.

Coming in SQL2K5 RTM (not in any of the current CTP's, but in more recent
builds), you can backup and then restore the database. On the restore, you
can specify a different database name and you get the data back w/o
reprocessing.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tiago Rente" <TiagoRente (AT) discussions (DOT) microsoft.com> wrote