Ispirer Ispirer
 

Third-party Tools

For the assessment of embedded SQL in Java application Ispirer uses tools Visual Studio or free toolkit jEdit. The assessment process is based on the finding of regular expressions.

Assessment process

In this conversion task we need convert only Embedded SQL from source database to target database and change connection string to database. Firstly, we need to identify how many LOC for database APIs functions/statements and embedded SQL are used in the source application? Using this information the estimations are provided. For the assessment of database APIs functions/statements and embedded SQL Ispirer uses tools Visual Studio or free toolkit jEdit (http://www.jedit.org/). How to assess?

LOC of code in your application

Usually every line is ends with end line symbol “\n”, so when we search for this symbol in the whole project we can count LOC for the all files.

1-sr.jpg

Results will look like in next screen:

1-res.jpg

Identified API statements usage

Depends on the project we need to find all places that corresponds to creating statements and executing it if we need to change it during migration. In common we need to find prepareStatement, prepareCall, but if you use different API we can count it too but with different RegExp.

1. Search for .prepareStatement

2. Search for .prepareCall

Identified SQL statements usage

The most valuable information for us is number of the DML statements and procedure’s calls. Using jEdit and regular expressions from bellow, we can count approximate number of such statements.

1. ”[ \t]*SELECT

2. ”[ \t]*INSERT

3. ”[ \t]*DELETE

4. ”[ \t]*UPDATE

NOTE: Depending on Database call statements could be different, so for each case we build different regular expression.

Contact us

Send all the information to Ispirer Support team . After all information is received we are analyzing it and provide estimation regarding time and price


Ispirer Home Page Ispirer SQLWays Product Page - COBOL Migration Request SQLWays

sqlways/java/migration-assessment/collecting-information/third-party-tools.txt · Last modified: April 16, 2013, 04:15:31 AM by roman
 
© 1999-2017, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement