After you use startSQLRepository to export repository data to an XML file, you can use the XML file to transfer this data to another database:

  1. Add a JDBC driver for your database and configure the JDBC connection pool. For more information, see the ATG Installation and Configuration Guide.

  2. Run startSQLRepository to import the contents of the XML file to the destination database with the following syntax:

    startSQLRepository -m module -import input-file 

  3. For example, given the earlier example, you can import the content from the Pioneer Cycling products.xml file as follows:

    startSQLRepository -m PioneerCycling -import products.xml
       -repository /atg/commerce/catalog/ProductCatalog