DatAdmin Personal 3.0.0

DatAdmin Personal 3.0.0 is an advanced and easy to use tool which is specially designed to give you a professional way to wok with  MySQL, MS SQL, SQLite, PostgreSQL and MS Access databases. It§s 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:

• DB backup of all objects - tables, viewa, procedures, functions, triggers
  
• Scheduling using Windows Scheduler service (only Professional edition)
  
• Database schema compare and synchronization (only Professional edition)
  
• More database and table export formats (Excel, WIKI, HTML)