User Tools

Site Tools


column_case

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
column_case [2016/10/14 16:00]
paul
column_case [2018/05/18 13:44] (current)
jackson.davenport
Line 3: Line 3:
 The Replicator Agent supports forcing of the column name to a configured case. **This configuration must be done prior to the Agent creating the table.** Two directives are available for inclusion within the agent.xml configuration file. The chosen directive must be placed within the <​task>​ tag. The Replicator Agent supports forcing of the column name to a configured case. **This configuration must be done prior to the Agent creating the table.** Two directives are available for inclusion within the agent.xml configuration file. The chosen directive must be placed within the <​task>​ tag.
  
 +==== Directives ====
 +You would use either of these directives in your agent.xml.
 <code xml> <code xml>
-<​task>​ 
     <​lowercase_columns/>​     <​lowercase_columns/>​
     <​uppercase_columns/>​     <​uppercase_columns/>​
-</​task>​ 
 </​code>​ </​code>​
  
-The default simply uses the original case of the column. If you happen to specify both, uppercase will be used.+==== Example agent.xml ==== 
 +<code xml> 
 +<?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​ 
 +<​config>​ 
 +    <​agent>​ 
 +        <​subscribe>​ 
 +            <​task>​ 
 +                <​task_name>​example_subscribe</​task_name>​ 
 +                <​message_connection password="​encrypt:​XXXX"​ user="​XXXX"​ queue="​..."​ >​amqp://​example.perspectium.net</​message_connection>​ 
 +                <​instance_connection password="​encrypt:​XXXX"​ user="​XXXX">​http://​example.service-now.com</​instance_connection>​ 
 +                <​handler>​com.perspectium.replicator.sql.SQLSubscriber</​handler>​ 
 +                <​decryption_key>​The cow jumped over the moon</​decryption_key>​ 
 +                <​database_type>​sqlserver</​database_type>​ 
 +                <​database_server>​MyAddress</​database_server>​ 
 +                <​database_port>​1433</​database_port>​ 
 +                <​database_user>​XXXX</​database_user>​ 
 +                <​database_password>​XXXX</​database_password>​ 
 +                <​database_parms></​database_parms>​ 
 +                <​database>​psp_repl</​database>​ 
 + 
 +                <​uppercase_columns/>​ 
 + 
 +            </​task> ​            
 +        </​subscribe>​ 
 +        <​max_reads_per_connect>​2000</​max_reads_per_connect>​ 
 +        <​polling_interval>​5</​polling_interval> ​    
 +    </​agent>​ 
 +</​config>​ 
 +</​code>​ 
 + 
 +The default ​(none of these directives) ​simply uses the original case of the column. If you happen to specify both, uppercase will be used.
  
 <WRAP round tip> <WRAP round tip>
column_case.txt · Last modified: 2018/05/18 13:44 by jackson.davenport