Overriding Database's Datatypes

Overriding Database's Datatypes property helps to override default datatype in the database. 

To enable this property, please follow the below steps.

1. 1. If table is already created/exist in database then set alter.schema.override=true in system.properties and alter.schema.size should be set to false
   2. Edit <used-Database>.properties under <<install-folder>>\dbsync-repl\WEB-INF\db\conf
   3. The datatype need to be overridden should be added like <old_datatype>.default=<new_datatype>
      eg. to override varchar to text, we can write varchar.default=text
      Note: This will change all varchar fields to new datatype or you can change the limit like Varchar (100) to Varchar (200) or any other number. 
      Remove the # tag before the picklist and save the changes and then run the build again.
      To change only for specific field use Force Property