Are there any MySQL Client applications for Windows that get even close to what the Enterprise Manager / Server Management Studio is for Microsoft SQL?
I have two requirements and one "nice to have" feature:
Editing table structure should not be a pain in the a** -> I don't want to click an "add another column" button, then edit the column's properties in a new window. What I want is adding a new row in a "column-list table" as it is done in the Management Studio.
Same applies to adding new rows to the table. Should be as easy as editing an Excel sheet.
Nice to have: I'd like to have a feature that's comparable to the database diagrams in the Management Studio, where I can visualize "foreign key relations" between tables. They don't actually need to become constraints [1] because I mainly use MyISAM (which doesn't support constraints). Just the diagrams are a lot of help.
Is there any application that you can recommend to me? Free would be a plus, but anything up to $100 would be okay, too.
[Update]
I'm going to test the recommended applications and give you an answer when I'm done.
I can give you an response to HeidiSQL at once, because that's one of the application's that I used before: Editing tables is a bit cumbersome, because most of the column's properties have to be edited in another window. Also it does not support character encoding, so I can't set my tables to "UTF-8". It does not have a diagram functionality. Editing data worked okay. So far HeidiSQL was one of the best application's I've tried... But there definitely is room for improval.
I just gave Toad for MySQL a quick glimpse:
Editing Tables is in the same way cumbersome as it is in HeidiSQL: When you try to add another column, a new window opens where you enter the columns properties. It does support character encodings (collations), though. While you are in "data" view and want to add a new row (data) to the table, you need to create that row by pressing a button first. Then you can enter data. That's not as "excel-like" as I'd like to see it. It should add a new row when I press "down" in the last row or click the mouse in the first blank row.
The diagram editor is not so user friendly either. When I pull in a new window and drop it in the editing area it is not put where I dropped it. Some auto-arranging goes on. Also the editor is real slow. With a 2.4 GHz dual core machine you shouldn't feel a latency while the flickering window border tries to follow your mouse.
Ergo: Also nice, but not even close to Microsoft.
As J Wynia mentioned in his post: MySQL Workbench is more about designing databases and exporting an "create" SQL script as it is about working with data. I haven't even found a function to connect to my database, so this is not what I'm looking for.
After a few moments of testing: I like SQLyog. Even though it has colors that hurt my eyes :)
Editing table: works nicely. Working with data: everything as expected. Running queries: I fell in love when I found the option to "Switch F5 and F9 functionalities". Exactly as in good ol' Query Analyzer.
There is no DB diagram feature, but I can live with that if I have to... In the end there's still Visio.
I might even consider paying money for this after some working with it.
Actually I don't think I really understand DbVisualizer. I get a window and when I open a database, it drops all tables in the drawing area. I can move them around, but I can't see an option to connect two tables, so I can't use it for real database diagrams. It displays the tables' contents nicely, but it seems to be read only. Best feature: There is a nice tab that tells me in big letters, that the table has XY rows. So very useless :)
Is there any editing functionality at all or is it just for browsing existing data?
Ah, I see. You have to pay $150 to get all editing functionality. Sorry, not with me.
I'd recommend you take a look at
SQLYog
[1]. The
free version
[2] is already rather good, but the paid version also has visual schema editing and comparison features. The UI has some tiny, but annoying shortcomings, but (the latest versions have solved those shortcomings completely -- Onno 20090331) overall I've been very pleased with it.
I can't live without Navicat [1]. An awesome GUI with native versions for Mac OSX, Windows and Linux. They also do versions for PostGresSQL and Oracle. Mysql version is $129 but if you're an individual, educational or non-profit, you get it for $95.
Worth every penny.
[1] http://www.navicat.com/I like to use Toad for MySQL [1] - freeware!
[1] http://www.toadworld.com/DOWNLOADS/Freeware/ToadforMySQLFreeware/tabid/561/Default.aspxI'm a big fan of dBForge Studio for MySQL [1] from devart.
[1] http://www.devart.com/dbforge/mysql/studio/Damn, I'd like to comment on the SQLyog answer, but I don't have the karma yet. I bought the developer version for about £70 for the schema sync button. Before I had this I kept a little list of all the things I was changing and refactoring in my test DB, then used this to update the live DB.
But with the sync tool you can just modify the test database as much as you like, then run the sync for a diff (as SQL commands) then save this somewhere. It saves so much time and effort!
I use HeidiSQL for those fast queries, when i need to check out the schema or some data. It is fast and lightweight.
When i need more complex work like tunning a query, exporting importing data, or altering the shema i launch toad for mysql.
EMS has free and paid versions of SQL managers for most database types as well as various other tools for working with databases.
http://sqlmanager.net/products/mysql/manager
I just use the free version.
Edit: For ease of data entry, there is a wizard that creates a form for you for entering the data you want for a record which makes adding data quite quick.
Definitely RazorSQL [1]. SQL editor, database browser, SQL generator, create / drop / alter tools. You name it, it has it.
[1] http://www.razorsql.com/I know this is an old question, but you might want to re-evaluate MySQL Workbench. It's currently a fully featured client, and the best open source cross platform tool for connecting to, querying, altering, and designing MySQL databases.
MySQL Workbench is available on MacOS, Fedora, Ubuntu, Windows.
WB 5.1 is focused on Data Modeling (replacing Mike Zinner’s popular DBDesigner product).
WB 5.2 (coming April 2009) will include a ground up rewrite of the MySQL Query Browser.
http://forums.mysql.com/index.php?151
MySQLWorkbench [1] is free for the basic version. $99/developer/year gets you live visual design of a running database, tools for versioning databases, lots of validation tools, etc.
The down side is that the free version is much more about designing a schema and exporting the SQL CREATE script than about being able to edit live data.
However, I've been using the free version of MySQLWorkbench in combination with SQLYog, which onnodb mentioned and haven't felt any real reason to kick in for either product so far.
I used to use DBDesigner until I went to MySQL5 (which it wouldn't connect to). That may have changed since I last used it, however.
[1] http://www.mysql.com/products/workbench/I've been using the free version of SQLYog for about a month. It's the best I've found so far.
http://sqlmanager.net/products/mysql/manager is the best tool
I would suggest you to try Navicat for MySQL [1]. There's Free Lite version.
It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc.
It is available for three platforms – Windows, Mac OS X and Linux. It connects users to any local/remote MySQL Server, providing several database utilities such as Data/Structure Synchronization, Import/Export, Backup and Report, to facilitate the process of maintaining data.
[1] http://www.navicat.com/download.htmli have used a few of these tools and none match MysqlFront for shear usability, intuitive user interface, almost non-existent learning curve. Every time I tried using any of the others I would get frustrated and going for MysqlFront. Many of them just take too long to get started doing anything productive. In all honesty, sqlyog, came closest, with navicat a bit more behind, for me.
But still ended up going back to MysqlFront, not as many annoying quirks.
Devart has both free and paid versions of dbForge Studi for MySQL [1].
I would recommend you to try this tool.
Devart Company
[1] http://www.devart.com/dbforge/mysql/studio/I really miss MYSQL Control center. I haven't liked the gui tools that they have released since they stopped that and I doubt I ever will, but I did really love the CC.
Toad is especially attractive if you work with different RDBMS's. Toad has free (and fuller featured pay) versions for Oracle, SQL Server, and DB2 as well and offers a consistent interface for all these databases. It's nice not having to get accustomed with mutliple GUI's.
Have you checked out the MySQL GUI Tools [1]?
It's very similar to Sql Server Management Studio. You can edit table schema and table rows like spreadsheet.
[1] http://dev.mysql.com/downloads/gui-tools/5.0.htmlIn a past life I have used DbVisualizer [1] which I found to be very good for #3. I don't remember trying it for either #1 or #2. Might be worth a shot.
[1] http://www.minq.se/products/dbvis/I've found Oracle's free SQL Developer to be particularly useful. You can use it with MySQL, Oracle, SQL Server and a few others plus you can install it on either Windows or Mac. Like several of the others mentioned, it has a few shortcomings but I definitely prefer it over the MySQL query tool.
NUcleon Database Master also supports MySQL database engine. It is modern all-in-one tool, supports MySQL, MongoDB, Oracle, Ingres, IBM DB2, Informix, Netezza, SQL Server, SQL Azure, FireBird, PostgreSQL, SQLite, EffiProz, ODBC, OleDB, FoxPro, dBase and XML files. It is innovative, powerful and easy-to-use software, which provides great features for developers and database users.
SQL Query: Database Master supports rich SQL Query editor with IntelliSense and Code Highlighting.
LINQ Query: Database Master supports LINQ to Entity Framework and LINQ to DataSet query technologies. This feature allows to users develop dynamic LINQ queries.
It has MSOffice Look&Feel and modern UI, can export data into most popular file formats like XML, HTML, CSV, MS Excel, MS Word, MS PowerPoint OpenOffice Calc and Writer, RTF, PDF, XPS, JSON, dBASE and PNG.
More About Database Master: http://www.nucleonsoftware.com
Go with Navicat, for sure. Everything you ask is there, and I think even more. Personally I like the fact that you can connect remotely via ssh. I know this is not what you ask, but that you ask is anyway there.
We use phpmyadmin. I know its not a desktop application but it can be installed on your PC and its pretty widely used and becoming familiar with it will help you as more things become cloud based. http://www.phpmyadmin.net
After a long search I've found Dreamcoder for Mysql [1]
It is totally free and it has some unique and advanced features which are not available even in other payed software of this kind.
I definitely recommend it !
[1] http://www.sqldeveloper.net/database-tools/mysql/overview.html