About Ispirer Systems
Ispirer Home Page Database Migration Application Conversion Downloads
SQLWays.xml file is a project file that stores information about the objects that were specified for conversion in a current migration process. Project file is created automatically by SQLWays tool and is stored in the project directory that should be specified on the “Welcome” page of SQLWays 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>
Example of the sqlways.xml file obtained by script conversion:
<DatabaseInfo> <SelectedObjects> <Scripts> <Script DDLFile="Bookings" file="S:\ASE\DDL_Objects\Tables\Bookings.sql" name="Bookings.sql"/> <Script DDLFile="Users" file="S:\ASE\DDL_Objects\Tables\Users.sql" name="Users.sql"/> <!-- Add as many Script entries as needed --> </Scripts> </SelectedObjects> </DatabaseInfo>
DDLFile – an internal identifier for the object, used for tracking during the conversion (can match the object name but doesn't have to).
file – the full file path to the source .sql file that will be included in the conversion.
name – the display name of the script, typically matching the filename.
If you have any questions on how to manually modify the project file before running the migration process, please contact our technical team: support@ispirer.com