DataDeploy DB to XML

Johnny

Just looking to confirm - from the examples and documentation, it looks like the DB to XML option can only deploy to a single XML file. I was looking for a nice way of creating DCRs from rows in a DB - essentially the reverse of a usual DataDeploy.

Can it be configured to create an XML file per row?

blacke

You code do something like this, where you specify the macro deployment to call a bunch of small select statements and they'll all print to your specified file (this example pulls out the schema tables and indexes from an oracle database):

<?xml version="1.0" encoding="UTF-8" ?>
<data-deploy-configuration>
  <data-deploy-elements filepath="/usr1/opendeploy/OpenDeployNG/etc/database.xml"/>
  <client>


    <deployment name="db-all">
      <exec-deployment use="db-table"/>
      <exec-deployment use="db-index"/>
    </deployment>

    <deployment name="db-table">
      <source>
        <database use="$dbname^" table="not-used">
          <db-producer-query>
            <![CDATA[
                      SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
                      FROM USER_TABLES u
            ]]>
          </db-producer-query>
        </database>
      </source>

      <destinations>
        <xml-formatted-data file="$destination^/tupleTable.xml">
        </xml-formatted-data>
      </destinations>

    </deployment>


    <deployment name="db-index">
      <source>
        <database use="$dbname^" table="not-used">
          <db-producer-query>
            <![CDATA[
                     SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
                     FROM USER_INDEXES u
            ]]>
          </db-producer-query>
        </database>
      </source>

      <destinations>
        <xml-formatted-data file="$destination^/tupleIndex.xml">
        </xml-formatted-data>
      </destinations>

    </deployment>
  </client>
</data-deploy-configuration>