Difference between revisions of "DatenbankFrontend"

From Dietrich Blog (Strato)
Jump to: navigation, search
(News)
(Replaced content with "Has been moved to: http://blog.kr8.de/wiki-datenbankfrontend/")
 
(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)
 

Latest revision as of 21:29, 24 April 2020

Has been moved to: http://blog.kr8.de/wiki-datenbankfrontend/