Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

PowerBuilder - Tuning and Running SQLWays for SRD and SRU Files Conversion

Now, when you have all the script files, you need to tune SQLWays command line tool to run their conversion. SQLWays processes all the files, extracts SQL statements and converts them to the syntax of the required database. Then all the statements are putted back to their places. The command line that needs to be run is as follows:

 sqlways.exe /f=d:\PB_source_scripts\*.* /source=PBScripts /target=PBScripts /dir=d:\PB_target_scripts

Where:
/f – folder containing all the script files
/source & /target – direction of the conversion
/dir – the directory containing the converted scripts

 NOTE: Please, pay attention that Source and Target in our conversion is “PBScript”.

The direction of the conversion for the Embedded in PB application SQL syntax is specified in the sqlways_wzd.ini file in the [COMMON] section for the options as in the example below:

 API_SOURCE_DB=Adaptive Server Enterprise
 API_TARGET_DB=Oracle


Ispirer Home Page Ispirer SQLWays Product Page - PowerBuilder Conversion Request SQLWays

sqlways/powerbuilder/tuning-running-srd-sru-files-conversion.txt · Last modified: March 20, 2013, 04:09:01 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement