Feature set for MS SQL, MySQL and Oracle

2009/12/10

Last modified: 2011-01-06

The following table shows the supported SQL dbms and testing features.

  MS SQL 2K MS SQL 2K5 MS SQL 2K8 MySQL 5.1 Oracle 10g express
Tables
Views
Sprocs/functions Limited*
Sproc/function – test method – ParameterIsSameAsColumn ** ** **
Triggers N/A
Synonyms N/A N/A
Test data sets returned √***
Security and permissions √**** Limited √****

* MySQL 5.1 does not implement INFORMATION_SCHEMA.PARAMETERS. Therefore not all of the frameworks testing functionality is available. It was introduced in MySQL 5.5 – so will be included once this version of MySQL is supported by the framework.

** Not implemented yet – will be implemented in a later version.

***Does not support testing data returned from sprocs. Issue with MS Enterprise Library and Oracle sprocs. Hope to fix in a future release.

****SQLObjectPermission introduced in version 0.3.3.410 will be implemented in a later version for Oracle. Will not be supported for MS SQL2K.

Advertisements