Compañeros, deseo hacer una copia de la estructura de una base de datos en
Olap services, el Analysis Manager me permite la opción Archive Database,
pero esto hace un backup que incluye los datos, y como son demasiados y no
los necesito, buso una opción que me permita tomar solo la estructura.


Gracias de antemno,



--
JOSE DAVID GALVIZ
MCAD
DCE 4 Estrella

Sorry, my knowledge of Spanish is poor; but I think you want to copy an
OLAP database without the cube data. This TechNet paper: "Microsoft SQL
Server 2000 Analysis Services Operations Guide" lists different ways of
copying/moving OLAP databases. The DSO/XML utility will save structural
information in XML, which can be edited and restored:

http://www.microsoft.com/technet/pro...ntain/anservog.
mspx#ESAA
Release Management

To move an Analysis Services database from the development environment
to the QA and production environment, you can choose between three
Microsoft supported mechanisms or an unsupported DSO/XML scripting
utility distributed by Microsoft.
...
Copying and Pasting

You can use Analysis Manager to copy the meta data for an Analysis
Services database from one instance of Analysis Services to another
Analysis Services instance, provided that both instances are registered
in Analysis Manager. Because only the meta data is copied to the target
server using this method for release management, you will need to
process the Analysis Services database on the destination server (after
updating the data source properties, if necessary) before users can
query the data in the new location.
...
DSO/XML Scripting Utility

You can also deploy Analysis Services objects using DSO/XML, an
unsupported utility that can create objects using definitions stored in
an XML file. This utility uses DSO to query an Analysis Services
instance and store XML definitions of the Analysis Services objects in
the instance into an XML file. You can then use DSO/XML to read the
definitions of these Analysis Services objects from the XML file and
recreate them on another Analysis Services instance. Before deploying
these stored definitions, you can edit the XML file with any text editor
to modify the definitions of these Analysis Services objects, such as
object names, data source names, and connection strings.

Microsoft provides the source code with this utility so that you can
embed its functionality directly into your management application. To
download or obtain more information on DSO/XML, go to
http://www.microsoft.com/downloads/d...d9e7a70-eef4-4
4c3-a0c5-deece0f8b4b4&displaylang=en.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!