Unit testing Tool for Sybase database

Question

Do we have any tools to unit testing Sybase databases around?

i am not able to find one in http://en.wikipedia.org/wiki/List_of_unit_testing_frameworks

i am looking out for a tool that can allow me to unit test Stored procedure.Something like wee do with utPLSQL.This tool will be used by Database guys to unit test.

Answer 1

What exactly do you want to test? The correctness of Sybase itself or some stored procedures you've written that run in Sybase? If the latter, then you could use JUnit to execute the stored procedures via JDBC (I'm assuming based on your username that Java is a language you're comfortable with).

Answer 2

Hi sunnyjava, Please try to use AnyDbTest first, (www.anydbtest.com). I think it is the very tool you are finding. even through the AnyDbTest is not support sybase at this moment. We are working to support Sybase these days.

Answer 3

I've been looking in to SqlUnit for xUnit level testing of stored procedures and such. It seems promising. I'm installing and fiddling with it now.