Multi-DB Administrator is an application developed in PHP that allow you administer your SQL Server, PostgreSQL and MySQL databases without the need of write any code(no php, neither sql) in an easy way, using an attractive web interface. You can export data from your tables in several file formats as CSV files, Excel files (XLS, XLSX), PDF files and SQL files. You also can import information from CSV, Excel (XLS, XSLX) and SQL files, directly in the table that you choose. The application also allows you to see, insert and edit the data saved in your database tables and make customized searches on it. If you are skilled in SQL you can execute your own queries (Insert, Update, Select, Delete, Drop, Create, etc.) And export your results in CSV, excel (XLS, XLSX) and PDF files. And finally you can create backup of the structure and data of your database, and restore it later.
Features:
- Easy Installation
- Allows local and remote connections
- You can save your connections settings from different databases. You only have to
- remember a password for use all your databases(SQL Server, PostgreSQL and MySQL)
- Compatible with MySQL, PostgreSQL and SQL Server Databases
- Support Windows and SQL Server Authentication for SQL Server Databases
- Export information in Excel(XLS, XLSX), CSV, PDF and SQL files
- Export Custom Query Results in Excel(XLS, XLSX), CSV and PDF
- Import information from Excel(XLS, XLSX), CSV, and SQL files
- Create and Recover Backups(BETA)
- Consult tables in a easy way with pagination included
- Custom Consult Visualization included
- SQL Queries Visualization and Execution(Select, Insert, Update, Delete, Create, etc.)
Requirements :
- IE 8.x, Firefox, Chrome, Safari or Opera Navigator
- A Web Server to run PHP
- PHP 5.2 or later
- Any edition of MySQL 5 or later
- Any edition of PostgreSQL 9 or later(You have to enable the extension php_pgsql.dll in your php configuration file – The documentation shows how to do it)
- Any edition of SQL Server 2005 or later (You have to download and install The Microsoft Drivers 3.0 for PHP – The documentation shows how to do it)
Changes in the version 1.1:
- Now you can save your connections settings from different databases. You only have to remember a password for use all your databases(SQL Server, PostgreSQL and MySQL)
- Now you can insert, edit and delete data from your tables directly using ajax
- Fixed some little bugs
- Improvements in the security
Changes in the version 2.0:
- Fixed issue with short tags in php
- Fixed issue with date-time fields in SQL Server
- Improved data update and delete using forms and ajax
- Implemented twitter bootstrap skin
