Description of the sqlways.xml file

Example of the sqlways.xml file with local and global data type mapping:

<?xml version="1.0" ?> 
<DatabaseInfo DatabaseName="TEST3" DbmsType="3" DbmsName="Adaptive Server Anywhere" DbmsVersion="09.00.0002" MajorDbmsVersion="9" MinorDbmsVersion="0"        DataDriverName="DBODBC9.DLL" DataDriverVersion="09.00.0002" ODBCVersion="03.52.0000">
 <SelectedObjects>
  <ResolvedDataTypes load="1">
    <DataType name="TEXT" type="LONG VARCHAR" length="2147483647" completeName="TEXT" target="VARCHAR" /> 
  </ResolvedDataTypes>
  <Tables load="1">
   <Table schema="CLAIMS" name="tb_claims" rows_search="" rows_search_using="0">
    <Columns>
     <Column name="col1" nullable="1" target="col12">
      <DataType name="INT" type="INTEGER" precision="10" minScale="0" maxScale="0" fixedPrecScale="No" completeName="INT" target="NUMERIC" /> 
     </Column>
    </Columns>
   </Table>
   <Table schema="CLAIMS" name="tb1" /> 
   <Table schema="CLAIMS" name="test1" /> 
   <Table schema="CLAIMS" name="test2" /> 
   <Table schema="DBA" name="APORTMAP" rows_search="" rows_search_using="0" /> 
  </Tables>
</SelectedObjects>
</DatabaseInfo>

Tag <DatabaseInfo> - describes database from which objects are selected.

Tag <SelectedObjects> - describes objects that should be converted.

Tag <ResolvedDataTypes> -describes global data type mapping that must be changed from default.

Tag <Tables> - represent all selected objects.

Tag <Table> - describe table.

Tag <Columns> - contain all columns in the table that must be changed from default conversion.

Tag <Column> - describe column name mapping.

Tag <Datatype> describe datatype mapping for specific column.

Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays