Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Description of the sqlways.xml file

SQLWays.xml file is a project file, that stores information about the objects that were specified for a conversion in a current migration process. Project file is created automatically by the SQLWays Wizard tool and is stored in the project directory, that we need to specify on the “Welcome” page in SQLWays Wizard tool.

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 the database from which objects are selected.

Tag <SelectedObjects> - describes objects to be converted.

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

Tag <Tables> - represents all selected objects.

Tag <Table> - describes the table.

Tag <Columns> - contains all columns in the table to be changed from default conversion.

Tag <Column> - describes column name mapping.

Tag <Datatype> describe datatype mapping for specific column.


If you will have any questions on how to manually modify the project file, before running the migration process, please contact our technical team: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-xml.txt · Last modified: March 02, 2018, 07:53:21 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement