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.