Exporting collections from one database to another

In rare situations, you may want to copy all collections and their associated connections from one database to another. You might do this, for example, because you want to collect similar data to another database.

To copy all collections and connections to another database

1. From a Command Prompt, execute the command

   runExportCollections [MetadataServerHostName] [MetadataServerPortNumber]
   

   This exports all collections and connections from an DevEnterprisedatabase to an XML file called importCollections.xml.

2. Open the Metadata Analyzer Configuration.
3. On the Database tab, change the Database name field to point to the new database that will contain the copied collections and connections, then click OK. Changes do not take effect until the Metadata Server is restarted.
4. Start the Metadata Server.

5. From a Command Prompt, execute the command

   runImportCollections [MetadataServerHostName] [MetadataServerPortNumber]
   

   where the host name and port number reference the Metadata Server started in the previous step. This will copy all collections and connections from the XML file, importCollections.xml, into the Metadata Server database.