Exporting Repository Data

You can export data from one database to another using the startSQLRepository utility. For example, you can export Pioneer Cycling data from a SOLID database to a neutral file form and then import it into another database, such as Oracle or Microsoft SQLServer, or from one SOLID database to another.

To export data using startSQLRepository, do the following:

  1. Make sure your SOLID database is running.

  2. Access the command prompt and switch to the <ATG2007.3dir>/home directory.

  3. Migrate the data from the SOLID database to an XML file. You can choose specific repositories to migrate, or you can migrate all the data in all the repositories.

    Exporting All Repositories
    To export the data from all SQL repositories registered in the /atg/registry/ContentRepositories component, issue the following command (type the following on one line, with no line breaks):

    bin/startSQLRepository -m module -exportRepositories all all.xml

    The location of the resulting file is relative to the <ATG2007.3dir>/home directory.

    Exporting Individual Repositories
    To specify individual repositories to export, issue the following command:

    bin/startSQLRepository -m module -export all file_name.xml
      -repository /atg/Path_to_Repository

    For example, to export the Product Catalog from the Pioneer Cycling store database into a file called products.xml, issue the following command:

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

    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.

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

  5. From the command prompt, switch to the <ATG2007.3dir>/home directory.

  6. Add the contents of the XML file to the destination database.

    Importing All Files
    To import the content from all the XML files, issue a command like this (type the following on one line, with no line breaks):

    bin/startSQLRepository -m PioneerCycling -import all.xml -repository
      /atg/userprofiling/ProfileAdapterRepository

    Importing Individual Files
    To import content from individual files, issue the following command:

    bin/startSQLRepository -m module -import file_name.xml
      -repository /atg/Path_to_Repository

    For example, to import the content from the Pioneer Cycling products.xml file, issue the following command:

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

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

 
loading table of contents...