Code Coverage tool for SQL Anywhere

[lucjan_chmura]

Hi,

is anyone aware about Code Coverage tool for SQL Anywhere. E.g. to track which lines of code within stored procedure,functions, and triggers that have been tested by an application/test scripts? Or, suggest how this could be done in SQLA.

thanks,

L

[yzzhang · Accepted solution]

Hi,

SQL Anywhere provide debugger to debug SQL stored procedures, triggers, event handlers, and user-defined functions you create. Simply start SQL Anywhere SQL Central connect to a database server, then click Mode -> Debug. The detailed information could refer to http://dcx.sap.com/index.html#sqla170/en/html/8196f2426ce210149629e49afd4e0833.html

Best regards,

[former_member194571]

Hi L,

I think you request is best satisfied using the SQL Anywhere Profiler tool. In SQLAny 17, you can start it from the Tools drop-down in the SQL Anywhere plug-in of SQL Central. In previous versions, it was part of the Application Profiling mode of Sybase Central. Here, number of executions and execution time are tracked on all database-side logic without having to interact on individual logic objects.

HTH

Volker