Handling ownership information

The XML utility schema allows you to handle ownership information about tables that have the same name but different owners. To use a copy of the dbeventstream.dtd or dbeventstream.xsd to parse XML data generated by RepConnector, after you install this API you must upgrade the file in the directory %REPRA_HOME%\dtds.

For example:

<your application server installation directory>\repra directory>

If you configure a replication definition for ownership of the table, RepConnector includes the owner name of the table or stored procedure in the output XML data.

Example 1

Output XML data without ownership information:

        <?xml version="1.0" encoding="UTF-8"?>
        <dbStream xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
     xsi:noNamespaceSchemaLocation="http://localhost:8000/RepraWebApp/dtds
        /dbeventstream.xsd" environment="RepConn.repdb">
        <tran
eventId="102:0000000000028cfc000007d8000f000007d8000c0000955700c0789e000
          000000001001">
        <delete schema=RepTable3">
         <oldValues>
          <cell name="repId" type="INT">1</cell>
         </oldValues>
        </delete>
        </tran>
      </dbStream>

Example 2

Output XML data with ownership information:

        <?xml version="1.0" encoding="UTF-8"?>
        <dbStream xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
     xsi:noNamespaceSchemaLocation="http://localhost:8000/RepraWebApp/dtds
        /dbeventstream.xsd" environment="RepConn.repdb" owner="dbo">
        <tran
eventId="102:0000000000028cfc000007d8000f000007d8000c0000955700c0789e000
        000000001001">
        <delete schema=RepTable3">
         <oldValues>
          <cell name="repId" type="INT">1</cell>
         </oldValues>
        </delete>
        </tran>
      </dbStream>