You can use the utility program startSQLRepository in order to read a repository definition from an XML file or DOM. startSQLRepository can perform these tasks:
Verify the XML is correctly formed and complies with the DTD.
Parse and process optional operation tags like
<add-item>,<remove-item>, and<query-items>. These tags provide a means for adding, removing, updating items in your SQL repository.Generate SQL statements that are required to create the appropriate database table structure when you use the
–outputSQLflag.Return results of
<query-items>and<print-item>requests in the form of<add-item>tags. This lets you easily copy and paste the results into another XML template, so you can add the items to another repository.Import and export items and item descriptors.
Note: When running startSQLRepository on a third-party application server, you must configure the server to use an Oracle ATG Web Commerce data source and transaction manager, not your native application server’s data source and transaction manager.
