DatAdmin Personal 3.0.4

DatAdmin Personal 3.0.4 is an advanced and intelligent tool designed to give you a professional way to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema.

Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. 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. 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.