You can use startSQLRepository to export data from a database to an XML file, which you can later import to another database. For example, you can export Pioneer Cycling data from a SOLID database to a neutral file form and import it into another database, such as Oracle or Microsoft SQLServer, or from one SOLID database to another.

You can export all repositories, or individual repositories from the specified modules. In both cases, first make sure the source database is running.

Exporting all repositories

To export the data from all SQL repositories registered in the /atg/registry/ContentRepositories component, use the following syntax:

bin/startSQLRepository -m module -exportRepositories all output-file

The location of the resulting file is relative to the <ATG9dir>/home directory.

Exporting individual repositories

To export the data from individual SQL repositories, use the following syntax:

bin/startSQLRepository -m module -export all output-file
   -repository repository-path

For example, the following command exports the Product Catalog from the Pioneer Cycling store database to products.xml:

bin/startSQLRepository -m PioneerCycling -export all products.xml
  -repository /atg/commerce/catalog/ProductCatalog

Note: when binary data in repository items is exported, it is represented in base64 encoding.

For additional information about exporting Pioneer Cycling repositories individually, see the ATG Consumer Commerce Solution Set Documentation. For information about exporting Motorprise repositories, see the ATG Business Commerce Reference Application Guide.

loading table of contents...