Built in query profiler that allows to profile the query and compare it with other queries. Debug your query, step by step, using the known watch, call stack and breakpoint concepts. GUI query builder and database builder. Drag and drop to build your own custom queries and database schema.
Good syntax completion and checker. Backup wizard that allows to schedule database backups. Allows storing code snippets.
Good support for running large SQL files without opening them. Cons: The full version has a high price tag on it, so not everyone will be able to afford it. Very basic JSON viewer for example, no ways to collapse or expand blocks of data. Users report that in some cases the auto complete feature stops working, whenever many connections are opened. Schedule database jobs - backup, restore, run reports and more.
Visual schema and query builders. Syntax completion and checker. The premium version allows collaboration with team mates - share queries, connections and more. Cons: High price point for the professional version. Visually design the schema tables, constraints and queries.
Schedule tasks like backup, restore, email notifications and more. Personalize the look and feel with themes.
The user interface is very customize-able. Fast and stable. Good data and schema sync tools. The Ultimate version comes with a good data comparison tool. Some users report occasional software crashes. Lack of support for databases other than MySQL. Their mission is to improve technology accessibility by providing a free and open SQL editor and database manager that is full-featured and easy to use.
HeidiSQL is free software, and has the aim to be easy to learn. People have reported SQuirreL working with the following. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
Migration also supports migrating from earlier versions of MySQL to the latest releases. Execute Query is an operating system independent database utility written entirely in Java.
The results of any executed statement is displayed in the results pane including database specific messages and error codes. Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. The tool allows you to create and execute queries, develop and debug routines, and automate database object management in the convenient environment.
To say nothing about the paid one, which is way ahead of these suggestions, in terms of SQL development, database design, and administration.
0コメント