Ispirer Website
Ispirer Toolkit Overview
Free Trial
First of all we need to open a command line window by running Start → Run → cmd.exe
Using tool for script conversion will help you to convert separate files with SQL code inside.
The command syntax is:
sqlways.exe /D=Fixed /SOURCE=<source DB> /TARGET=<target DB> /DIR=<result_directory> /PRJF=<project_file_path> /INI=<ini_file_path> /TRACE /RPT_TYPE=1
Note: SQLWays command line options are case insensitive and their order is insignificant.
Here is the list of parameters used in the provided command line:
Optional parameters:
Information about all the supported command line options can be found here: Command Line Options
Sample of the command line:
"C:\Program Files\Ispirer\IspirerToolkit10\sqlways.exe" /D=FIXED /PRJF="C:\Users\User1\Documents\Ispirer\CodeWays 10\sqlways.xml" /DIR="C:\Users\User1\Documents\Ispirer\CodeWays 10\Result" /SOURCE=Adaptive Server Enterprise /TARGET=Microsoft SQL Server /INI="C:\Users\User1\Documents\Ispirer\CodeWays 10\sqlways_app.ini" /TRACE /RPT_TYPE=1
The easiest way to prepare correct command line is to run the Ispirer CodeWays tool, select all the required objects for conversion and on the “Summary” page, you will see the generated command line:
You can just copy the generated command line and run it.
After we prepared the command line with appropriate set of options we need to run it in the command line prompt.
And as a result, in directory specified in /DIR option you may find the following files generated:
Thus, the conversion process is finished.
When performing script-based migration using the Ispirer Toolkit in command-line mode, you can control which scripts are included in the conversion by configuring the sqlways.xml project file. This is particularly useful when you want to convert only a subset of objects instead of processing all files in a folder.
To include specific SQL script files for conversion, use the <Scripts> section within the <SelectedObjects> block in your sqlways.xml file. Each script is represented by a <Script> element, where you define:
Example:
<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>
In this example, only the Bookings.sql and Users.sql files will be included in the migration process. All other scripts will be ignored.
Once you've configured the sqlways.xml file to include only the desired scripts:
Only the files listed in the <Scripts> block will be processed and converted.
If you have any questions on how to run the migration in batch mode, please contact our technical team: support@ispirer.com