Use the XML utility schema to manage 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 %REPRA_HOME%\dtds.
<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.
<?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>
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>