This section describes the process to copy the contents of one database to another database. It can be used, for example, to copy the updated contents of the product catalog/price lists database on an administration server to the product catalog/price lists database on a staging server.

Note: You must have read, write and delete permissions, as well as import and export permissions, to perform the database copy. If you do not have the appropriate permissions, ask your database administrator to copy the database.

To perform a database copy of the product catalog and price lists data:

  1. Make sure the configuration file of the DBCopier you are using has been updated to account for any database tables you have created or deleted. (See Configuring a Database Copy for a code example of a DBCopier configuration file.)

  2. Access the Commerce Administration page of the Dynamo Server Admin using the port appropriate for your application server. See the Platform Installation and Configuration Guide for information.

    Note: Your application must include the Dynamo Server Admin in order for you to access this page.

  3. Click the Copy Commerce Data link.

    The system displays the Product Catalog and Price Lists Copy page.

  4. Enter the Server Name, Username, and Password for the Source database.

  5. Enter the Server Name, Username, and Password for the Destination database.

  6. Click the Copy button.

    The contents of the Source database are copied into the Destination database. Note that the time it takes to perform the database copy depends on the size of the database.


Copyright © 1997, 2016 Oracle and/or its affiliates. All rights reserved. Legal Notices