How Does SQLWays Classify Errors

  • There are three types of errors that might occur during the migration:

    1. Export error – when the tool cannot recognize any part of the source code. In this case the error is raised on the export and depicted in the sqlways.log file after the migration.

    2. Import error – when the tool performed the conversion incorrectly or it doesn’t correspond to the syntax supported in the database. In this case the error is raised on the import and depicted in the sqlways_imp.log after the migration.

    3. BL (Business Logic) error – sometimes the target (result) syntax is correct, but it works incorrectly. The object is created, but returns the result different from the one which is returned by the source SQL Code or it simply returns an error. BL error is the most difficult to find error as it raised only when you check the work of the target database manually or through the application using the converted database.



More about Ispirer Systems