The Perl DBI module is a simple Perl database interface to execute queries and for getting the results back.
DBI doesn’t know how to connect to any particular database, but it knows how to load the appropriate DBD (`Database Driver’) module. The DBD modules have the required libraries in them and know how to talk to the real database; DBI needs a DBD module for every different database. When you use the DBI Module to run a query, it sends the query to the DBD module which is the one who talks directly to the real database.
With this plugins you can perform two main tasks:
- Execute sql scripts from sql files or from the text area located in the parameter form.
- Create backups for your databases
The plugin executes the sql code against databases by using the Perl’s DBI Module. This means that you will need to have installed the corresponding DBD Module.
DBD-mysql and DBD-ODBC are installed by default, so you would have access to MYSQL and SQL Server or any preconfigured ODBC connection out of the box.
Additional DBD Modules are required for Oracle, Postgres and SQLite.
On the other hand this plugins creates database backups by calling different command-line tools that almost every database uses.
For example Mysql => mysqldump, SQL Server => osql, Oracle => exp and Postgres => pg_dump.
This plugin can interact to the following databases:
- SQL Server (through ODBC)
- Supported database versions
- SQL Server – SQL Server 2008
- MySQL – MySQL 5.5
- Oracle – Oracle 9.2 or later
- SQLite – SQLite 3.7.7
- Postgres – Postgres 8.4 or later