maybe it is easy but I havn´t found it...
thanks for you help!

Christian

I don't think you can rename a DB. However, you can create a copy of it
(Copy...Paste). It prompts you to give the new DB a different name,
when you do the paste.

Christian wrote:

AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
discusses this.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Christian" <christian.freydl (AT) mehrdata (DOT) com> wrote

AS2000 is lacking many DDL type operations that you get with RDBMS's. It
doesn't give you a function to rename a db (even in DSO), which is a right
pain if you want to do operations like building offline, and then swapping
db's. Also, if you copy and paste a db, the data doesn't get copied, just the
definition.

If you've got the nerve for it, you can rename a db though, as follows (best
to try this on a non-critical db first because it involves manual repository
changes which, if wrongly applied, could blow up your AS2000):


1. Shut down the MSSQLServerOLAPService service.

2. Open the OlapObjects table of the repository. If your repository is an
..mdb file (default) then it'll typically be in c:\program files\microsoft
analysis services\bin\msmdrep.mdb. You can open it with MS Access.

3. In the OlapObjects table, find the record where ObjectName is the name of
your db, and the ClassType column is 2. Change the ObjectName to be the new
database name. You must also change the database name in the ObjectDefinition
column where you see <DATABASE Name="<old db name>" .... change the old db
name to the new one.

4. Find the data directory of the db you want to change. By default this
would typically be c:\program files\microsoft analysis services\data\<old db
name> . You must rename the data directory from the old db name to the new
name.

5. Find the .odb file. By default this would typically be c:\program
files\microsoft analysis services\data\<old db name>.odb . You must rename
this .odb file to the new name of the db.

6. Start the MSSQLServerOLAPService and your olap db will have appear with
the new name. Easy (!)


You try that at your own risk.





"Christian" wrote: