DatenbankFrontend
From Dietrich Blog (Strato)
Contents
Datenbank-Frontends
Es gibt zwei Schwerpunkte der Anwendung:
- Für den DB-Administrator (Anlegen von Datenbank-Objekten, Rechte etc.)
- Für den Entwickler (Formulare, ReportGenerator,...)
Meine Anforderungen
- Create databases and tables
- Rename databases and tables
- Drop databases and tables
- View table structure
- View table data as datasheet (i.e. tabular view) including BLOB columns
- Change table structure (Alter)
- Edit table data (in tablular datasheet view) including BLOB columns
- GUI-Editing: Copy and paste table rows via clipboard to/from other applications (e.g. MS Excel, MS Access,...)
- Export table structure as SQL script (Reverse engineer DDL)
- Export table data as SQL script
- Execute SQL scripts (Import table structures/data)
- Connect to local and remote MySQL databases
- Connect simultaneously to two MySQL servers, copy tables between databases on different servers
- Import tables (structure and/or data) from non-MySQL sources (e.g. ODBC sources)
- Create and change users
Meine Produktliste
- DBManager Professional 2.2.0 http://www.dbtools.com.br
- DbVisualizer 3.31 (Java / Cross Platform) http://www.minq.se
- MYdbPAL Version 3 (freeware) http://www.it-map.com
- MySQL-Front 2.5 http://www.anse.de (Nov 2002: Die letzte Freeware-Version von Ansgar Becker. Der neue Autor N.Hoyer hat Shareware daraus gemacht.)
- Navicat 2004 Version 6.0.7 http://www.navicat.com
- PhpMyAdmin 2.6.0 (PHP Web Application) http://www.phpmyadmin.net
- SQLyog v3.11 (freeware) http://www.sqlyog.com
Weitere Tools
- DBExplorer http://www.silk.co.nz (kommerziell, gut um schnell mal in alle ODBC Sources zu schauen....)
- openDBcopy http://sourceforge.net/projects/ (Nettes Kopier-Tool auf Jave/XML-Basis, noch nicht ausgereift)
Meine Bewertungen
| Produkt | Pros | Cons |
| DBManager | MySQL, PostgreSQL, SQLite, Xbase Imports tables via ODBC/DAO Exports tables to MS Access (DAO) |
GUI-Editing: copy only, no paste not blob view/edit |
| DbVisualizer | Java based Easy GUI viewer to all JDBC/ODBC databases |
very simple export function only, no import |
| MYdbPAL | ... | ... |
| MySQL-Front | Multiple server connections Copy tables between databases Supports BLOBs Imports tables via OBDC |
Vom Original-Autor Ansgar Becker abgegeben... |
| Navicat | Multiple server connections Copy tables between databases Supports BLOBs Table import wizard (including OBDC) Table export wizard (including MS Access) Copy table rows to clipboard Paste table rows from clipboard |
MySQL only ODBC import hat Probleme mit einigen Datenformaten |
| PhpMyAdmin | OpenSourceSoftware, WebApplication auf Basis von PHP,... |
... |
| SQLyog | Supports BLOBs Multiple server connections Table export as SQL script Copy tables between databases Copy table rows to clipboard Import tables via ODBC (v3.11 free) |
MySQL only Cannot paste table rows from clipboard |
Meine Auswahl
Navicat: Als hauptsächliches Dantenbank-Frontend für das Editieren der Dateninhalte DBManager: Für ODBC-Import PhpMyAdmin: Wenn es zwingend auf einem Web-Server laufen muss (z.B. beim WebProvider) MYdbPAL: Für wiederkehrende ETL-Aufgaben
News
SQLyog v3.51 - The definitive Windows Front End for MySQL, has been released.
SQLyog is a superfast, compact and easy to use Front End for MySQL.
Some of the new features added in SQLyog 3.51 are -
- Complete support for MySQL 4.1.
- Improved SQL Editor.
- Improved ODBC Import Tool.
- BLOB data does not require double click for viewing if the data is < 255 bytes.
- More compact and optimized executable ( 480 KB ).
- Lot of bugfixes and enhancements.
SQLyog 3.51 is available at an Introductory price of $49.
You can download a full featured Trial version of SQLyog at http://www.webyog.com/sqlyog/download.html
Regards,
