| Steve G 2005-11-24, 3:23 am |
| 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 MSSQLServerOLAPServi
ce 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 MSSQLServerOLAPServi
ce and your olap db will have appear with
the new name. Easy (!)
You try that at your own risk.
"Christian" wrote:
> maybe it is easy but I havn´t found it...
> thanks for you help!
>
> Christian
>
>
>
|