Database Specific Plugins
Database plugin in WinSQL starts where ODBC API ends; it adds functionality that is not available through ODBC. Features like:
To select a plugin pick the desired database type from the connection window.
 |
Triggers
Script for Stored Procedures and Views
Database specific features like sequences in Oracle and rules in MS SQL Server
and more...
Here is how it works:
These plugins are nothing but plain text files in XML format,
which provide WinSQL necessary SQL statements to fetch the required data.
XML has become a de facto standard to store configuration files and many programmers/DBA's are already familiar with it. This makes very easy to add new plugins and modify existing ones.
Plugins for the following databases comes bundled with WinSQL
Oracle
DB2/UDB
MS SQL Server
Informix
Sybase
PostgreSQL
Pervasive SQL
If you work with a database that is not listed above, you can add your own plugin. Please refer to WinSQL User's guide for instructions
|
