DatAdmin Personal 2.3.1

Datadmin Personal 2.3.1 is designed as a professional application which can allow you natively to support MSSQL, MySQL, SQLite, Postgre SQL, MS Access. In addition, this tool can be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV), edit database schema.

Moreover, other functions: run queries, view data in tables of any size, generating query templates (create/update/delete), editing database objects (view, triggers, stored procedures), viewing lookup fields in foreign-key tables. Canceling queries and data loading. Next more advanced functions are supported in Proffesional edition.

Major features

1. SQL command execution, browsing results in grid
2. Visual database management, displaying database structure in tree, modifying table structure
3. Visual editing of table structure, including defining primary and foreign keys, indexes, check and unique constraints.
4. Editing data in tables of any size
5. Native access to MySQL, SQLite, MS SQL Server, MS Access and Postgre SQL, support for all data types
6. Export and import tabular data from/to CSV, XML
7. Drag & Drop operations with tables and databases, copying tables and databases also between different databases
8. Generating SQL templates for create, update delete SQL commands
9. PHP tunnel function allows user connection to database accessible only ofrom PHP scripts
10. Database design, which is independend on target database.
11. Showing lookup fields in data grid
12. Long-running operations (queries, data loading, prcoesses - backuping, exporting table data) can be canceled
13. Managing of view, triggers, stored procedures and functions
14. Export and import data to/from Data Archive, which is database backup independend on database platform
15. Export and import tabular data from/to HTML, SQL, customizable XML
16. Creating database diagrams, possibility to create diagram styles, two prepared styles Automatic master/detail view (based on foreign keys defined in database)
17. Query designer

    WareSeeker Editor