"Yash" <yashgt (AT) yahoo (DOT) com> wrote

There are few Metadata scripters available (both free and commercial)

http://msdn.microsoft.com/library/de...ml/sql01f1.asp -
Microsoft SQL Server Resource Kit
http://www.winsight.fr/DOWNLOAD/W00DLD001U.asp#8 - Winsight XML OLAP
meta-data import/export utility
http://www.mosaicinteractive.com/mit...ProductID=0103 -
DSO/XML conversion by MosaicInteractive - This utility round-trip converts
DSO metadata to/from standalone XML files. Specifically, it allows for DSO
metadata (dimension/cube structures, etc.) to be converted into XML and
allows for the resulting XML to be converted back into DSO structures. It
describes the entire DSO object model and allows you to script objects for
add, remove or replace (similar to the SQL 2000 QA). This tool allows you as
a developer to distribute OLAP/Analysis Services solutions in such a way
that a person can completely install the solution (including DTS) through a
wizard in minutes even if they know nothing at all about OLAP/Analysis
Services. It even provides a mechanism for instant documentation of your
OLAP/Analysis Services solution.
http://groups.msn.com/MicrosoftOLAPS...pgmarket=en-us -
OLAP Script Generator by ramkoth_p - This tool is intended to be used for
scripting OLAP Database definitions to an XML based script file and creating
a new OLAP database from the script.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Hi,

Have you looked at Meta Data Scripter from the SQL resource kit.

few bytes from BOL of the reskit:

Meta Data Scripter (MetaDataScripter)
The Meta Data Scripter (MetaDataScripter) sample is located in the
ToolsAndSamples\MetaDataScripter folder on this Microsoft SQL Server 2000
Resource Kit CD.

The Meta Data Scripter sample provides an excellent way to exploit the
features of Decision Support Objects (DSO). You can use the Meta Data
Scripter for tasks such as repopulating meta data for objects, copying meta
data for objects to a different database, creating copies of objects on
different servers, in different databases, or with different names.

The Meta Data Scripter consists of a Microsoft® Visual Basic® 6.0 ActiveX®
DLL project used to construct an add-in for Microsoft SQL Server™ 2000
Analysis Services, as well as two Microsoft Visual Basic Scripting Edition
(VBScript) template files. The add-in enables you to script the meta data
of any object, including dependent objects, that can be selected in
Analysis Manager. The add-in generates a VBScript file that uses DSO to
re-create the scripted objects.

The routines that use DSO to re-create the scripted objects are contained
in the Footer.vbs template file included with the sample. The global
variables used by the generated VBScript script file are contained in the
Header.vbs template file, also supplied with the sample. The Analysis
Services add-in copies both files into the generated VBScript file.


HTH,
Bas