|
|
(One intermediate revision by the same user not shown) |
Line 1: |
Line 1: |
− | {{TOCright}}
| + | Has been moved to: http://blog.kr8.de/wiki-datenbankfrontend/ |
− | 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|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|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|Navicat]] 2004 Version 6.0.7 http://www.navicat.com
| |
− | * PhpMyAdmin 2.6.0 (PHP Web Application) http://www.phpmyadmin.net
| |
− | * [[SQLyog|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 ==
| |
− | {| class=wikitable
| |
− | |-
| |
− | | '''Produkt''' || '''Pros''' || '''Cons'''
| |
− | |-
| |
− | | [[DBManager|DBManager]] || MySQL, PostgreSQL, SQLite, Xbase <br />Imports tables via ODBC/DAO <br />Exports tables to MS Access (DAO) || GUI-Editing: copy only, no paste <br /> not blob view/edit
| |
− | |-
| |
− | | DbVisualizer || Java based <br />Easy GUI viewer to all JDBC/ODBC databases || very simple export function only, no import
| |
− | |-
| |
− | | MYdbPAL || ... || ...
| |
− | |-
| |
− | | [[MySQL-Front|MySQL-Front]] || Multiple server connections <br />Copy tables between databases <br />Supports BLOBs <br />Imports tables via OBDC || Vom Original-Autor Ansgar Becker abgegeben...
| |
− | |-
| |
− | | [[Navicat|Navicat]] || Multiple server connections <br />Copy tables between databases <br />Supports BLOBs <br />Table import wizard (including OBDC) <br />Table export wizard (including MS Access) <br />Copy table rows to clipboard <br />Paste table rows from clipboard || MySQL only <br />ODBC import hat Probleme mit einigen Datenformaten
| |
− | |-
| |
− | | PhpMyAdmin || OpenSourceSoftware,<br /> WebApplication auf Basis von PHP,... || ...
| |
− | |-
| |
− | | [[SQLyog|SQLyog]] || Supports BLOBs <br />Multiple server connections <br />Table export as SQL script <br />Copy tables between databases <br />Copy table rows to clipboard <br />Import tables via ODBC (v3.11 free) || MySQL only <br /> Cannot paste table rows from clipboard
| |
− | | |
− | |}
| |
− | | |
− | ==Meine Auswahl ==
| |
− | [[Navicat|Navicat]]: Als hauptsächliches Dantenbank-Frontend für das Editieren der Dateninhalte
| |
− | [[DBManager|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|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, ...
| |
− | | |
− | | |
− | -- [[User:Dkracht|Dkracht]] 11:39, 29 March 2008 (CET)
| |