Is anyone aware of a unit testing framework for SQL Anywhere
stored procedures (in particular for SQL Anywhere 9.0.2)? I
have been looking at TSQL Unit for SQL Server 2008.

Phil

I could not find it (few years ago).

We build our own SP Unittest tool in PowerBuilder.
Per Stored Procedure that we want to Unit test we create a small PB
script that executes the SP with several input parameters. The result is
export with a datawindow. When we change the SP and checkin the new
version the tool is runned and checked the results of the new version
with the original ones. If there are differs you will get a warning.
Then you have to check if the diffs are caused by an error in new SP
version or that you solved an error in the old version.

IF you are a PowerBuilder programmer I can send yoy some start scripts.

Bye
Hans

Philip Harris schreef:

Thanks for the reply, I think if we did do something
ourselves we would probably write the unit test framework in
TSQL and C# as the business is quite strict about what
technologies we use. (but thank you very much for the
offer!)

Hopefully a simple unit testing framework wont take more
than a few days to write.

Regards

Phil