Feature set for MS SQL, MySQL and Oracle

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: