Editor: DatAdmin is database administration tool that allows working 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 with some specialized programs. Personal Edition is freeware for non-commercial use.
Functionality
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.
Database management
Creating and editing of tables, keys and references. Database object management (views, procedures, functions, schemata, triggers). Support for specific Database Objects MySQL versions 4.x, 5.x, MS SQL 2000, 2005, 2008.
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.
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. Scheduling. Copying tables using drag & drop, also Between different servers.
Database design, compare databases
Editing database models, table structure. Database Diagrams. Synchronization with real database. Compare Database schemata.
SQL Editor
Graphics deisgn of query, syntax highlighting. Saving query to connection locally or on server.
