Sample sharded file for moving colonies to Production_V2

You can review the sample sharded file XML for moving colonies to the Production_V2 environment.

?xml version="1.0" encoding="UTF-8"?>  
<colonyconfig>  
   <pools>  
      <pool id="DEFAULT_METADATA"> 
         <jdbc>  
           <param name="url" value="<url to connect to database>"/>  
           <param name="user" value=”<Production_V1_METADATA> "/>  
           <param name="password" value=”<Production_V1_METADATA> "/>  
           <param name="dbvendor" value="<database vendor name - either db2 or oracle> "/>  
           <param name="driver" value="<class name of your database driver>"/> 
           <param name="schema" value="<Production_V1_METADATA> "/> 
        </jdbc>  
      </pool>  
      <pool id="DEFAULT_STATISTICS_10">  
        <jdbc> 
           <param name="url" value="<url to connect to database>"/> 
           <param name="user" value="<Production_V2_STATISTICS> "/> 
           <param name="password" value="<Production_V2_STATISTICS> "/> 
           <param name="dbvendor" value="<database vendor name - either db2 or oracle> "/> 
           <param name="driver" value="<class name of your database driver> "/> 
           <param name="schema" value="<Production_V2_STATITICS> "/> 
          </jdbc> 
      </pool> 
      <pool id="DEFAULT_CONFIGURATION_10"> 
         <jdbc> 
           <param name="url" value="<url to connect to database>"/> 
           <param name="user" value="<Production_V2_CONFIGURATION>"/> 
           <param name="password" value="<Production_V2_CONFIGURATION> "/> 
           <param name="dbvendor" value="<database vendor name - either db2 or oracle> "/> 
           <param name="driver" value="<class name of your database driver>"/> 
           <param name="schema" value="<Production_V2_CONFIGURATION> "/> 
         </jdbc> 
      </pool>  
      <pool id="DEFAULT_TRANSACTION_10">  
         <jdbc> 
           <param name="url" value="<url to connect to database>"/> 
           <param name="user" value="<Production_V2_DEFAULT_TRANSACTION>">/> 
           <param name="password" value="<Production_V2_DEFAULT_TRANSACTION>"/>  
           <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/>  
           <param name="driver" value="<class name of your database driver>"/>  
           <param name="schema" value="<Production_V2_DEFAULT_TRANSACTION>"/> 
        </jdbc> 
     </pool> 
     <pool id="TRANSACTION-01"> 
        <jdbc>  
          <param name="url" value="<url to connect to database>"/>  
          <param name="user" value="<Colony_01_TRANSACTION>"/> 
          <param name="password" value="<Colony_01_TRANSACTION>"/> 
          <param name="dbvendor" value="<database vendor name - either db2 or oracle>"/> 
          <param name="driver" value="<class name of your database driver>"/>  
          <param name="schema" value="<Colony_01_TRANSACTION>"/>  
       </jdbc>  
     </pool> 
   </pools>  
   <colonies>  
    <colony name="Colony-01" version="9.5" newversion="10.0" 
    status="" pkprefix="11">
        <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/> 
        <schema poolid="DEFAULT_CONFIGURATION_94" tabletype="CONFIGURATION"/>
        <schema poolid="DEFAULT_STATISTICS_94" tabletype="STATISTICS"/>
        <schema poolid="TRANSACTION-01" tabletype="TRANSACTION"/>
        <schema poolid="TRANSACTION-01" tabletype="MASTER"/> 
    </colony>
    <colony name="DEFAULT" version="10.0" pkprefix="20"> 
        <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/> 
        <schema poolid="DEFAULT_CONFIGURATION_94" tabletype="CONFIGURATION"/>
        <schema poolid="DEFAULT_STATISTICS_94" tabletype="STATISTICS"/>
        <schema poolid="DEFAULT_TRANSACTION_94" tabletype="TRANSACTION"/> 
        <schema poolid="DEFAULT_TRANSACTION_94" tabletype="MASTER"/>
    </colony> 
   </colonies> 
</colonyconfig>