DatAdmin Personal 3.0.3

DatAdmin Personal 3.0.3 offers you an easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also can be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema.

DatAdmin is universal tool that allows working with  MySQL, MS SQL, SQLite, PostgreSQL and MS Access databases. Its design is focused to be easily used, thanks to modularity and flexibility can be functionally compared aos with some specialized programs. Program is freeware for non-commercial use.

Major Features:

1. Connect to database
   • Connect using native ADO.NET drivers ODBC, OLE DB. Native support for Microsoft SQL Server, MySQL, Postgre SQL, SQLite, MS Access. Function PHP-tunnel for connecting to MySQL without direct access to database server.
2. Database management
   • Creating and editing of tables, keys and references. Database object management (view, procedures, functions, schemata, triggers). Support for specific database objects MySQL versions 4.x, 5.x, MS SQL 2000, 2005, 2008.
3. View and edit data
   • Editor of table data with unique functions. Paging, filtering, searching, generating SQL for data row (UPDATE, INSERT, etc.). View lookups, automatic master/detail views.
4. Backuping, exports, imports
   • Backup, export and import of database. Exports, imports of table data from/into formats CSV, TXT, HTML, XML, Excel etc. Ability to run from command line. Schediling. Copying tables using drag & drop, also between different servers.
5. Database design, compare databases
   • Editing database models, table structure. Database diagrams. Synchronization with real database. Compare database schemata.
6. SQL Editor
   • Graphics deisgn of query, syntax highlighting. Saving query to connection locally or on server.

Enhancements:

WareSeeker Editor