Previous Topic: Order of Exporting and Importing MDB ObjectsNext Topic: import method—Import MDB Objects


export method—Export MDB Objects

The export method exports MDB objects from a source MDB. It creates an XML file for each object that matches the specified object name or pattern. The XML files are named as follows:

ObjectType__ObjectName__(counter).xml

Example: XML file name

BoQueryDef__Asset is a Virtual Machine - MS Virtual PC__(1).xml

This command has the following format:

mdbac.bat -export MDB_Object_Type -name Object_Name - work workfolder -source Connection_Name {-user User_Name -pwd Password | -wallet wallet_file_name} 
MDB_Object_Types

Specifies the MDB object type that you want to export.

Note: For a list of supported MDB object types, see the "Supported MDB Object Types" appendix.

Object_Name

Specifies the object name in the given object type that you want to export. You can use wildcard characters to match a pattern. For example, you can specify "Asset%" to process all the objects that start with the name "Asset" in the given object type.

Example: Export MDB Objects

This example command exports queries that start with the object name "Asset is a Virtual Machine" from a specified SQL MDB:

mdbac.bat -export BoQueryDef -name "Asset is a Virtual Machine%" -work C:\TEMP\work -source mssql -user ca_itrm -pwd password123

Example: Using the Wallet Argument

mdbac.bat -export BoQueryDef -name "Asset is a Virtual Machine%" -work C:\TEMP\work -source mssql -wallet dbwallet