Go to devart.uservoice.com and share your ideas about new features you want to see in dbForge Studio for MySQL. Here you can do the following:

• Vote for features that are already in our roadmap, and they will get higher priority in our plans
• Suggest your own features, and if they get enough votes, we will include them to the roadmap.

Your opinion helps us to make our MySQL GUI Client better and more useful for you.

We have already started implementing the following features:

(more…)

Changes (as compared to 4.50.308) include:
Bug fixes:
* Removed spaces in the integer and float format in Data Export wizard (T23612)
* Fixed NullReferenceException on saving a database project with opened table editors (T23519)
* Fixed NullReferenceException on deleting a table from a database with an opened inactive editor (T56081)
* Fixed NullReferenceException on auto hiding a tool window (T56033)
* Added possibility to edit a definer for triggers in the trigger editor (T23357)
* Fixed problem with BINARY(16) column type on selecting its data to the Data Editor (T23292)
* Fixed problem with empty gray windows after editing a table in the modal editor from Database Designer (T23164, T23018)
* Fixed link on the first page in the product tour (55629)
* Fixed syntax checking for some constructions in CREATE TABLE statements (55161)
* Fixed lost connection on the data comparing (T22521)
* Impossibility to disable Code Completion in the Express edition was fixed (54932)
* Files in database projects are saved with a relative path now (54378)

Downloads: http://www.devart.com/dbforge/mysql/studio/download.html
Ordering: http://www.devart.com/dbforge/mysql/studio/ordering.html

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

Question:
How to create a database diagram basing on the image available?

(more…)

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by a community vote.

Devart has been nominated in 4 categories of 2010 DevProConnections Community Choice Awards!
Nominated products:

• Best Add-In Product – Entity Developer (page 1, category 1: Add-In)
• Best Component Set – dotConnect for Oracle (page1, category 7: Component Set)
• Best IDE Product – dbForge Studio for MySQL (page 2, category 14: IDE)
• Best Free Tool – CodeCompare (page2, category 26: Free Tool )

If some of your favorite products are in that list, please visit: http://www.surveymonkey.com/s/DEVCommChoiceFinalVoting and cast your vote for your favorite Devart products.

Note: Voting ends on September 21, 2010.

Thank you and best wishes,
The Devart Team
www.devart.com

To get information from a database it is necessary to execute a query to get this data.

Usually an ordinary SQL editor is used to create queries. To use such editor, one should remember the syntax of the SELECT operator and the names of tables and columns.

Let’s use a visual instrument developed specially to design queries, and see that it’s much easier to create queries visually instead of typing them in an editor.

Task:

It’s necessary to show the salaries of the employees of departments situated in different cities for the 2008 year in descending order.

(more…)

The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.

(more…)

In one of our posts, in the Be Careful While Using UNSIGNED Data Type in the Routine Body one, we’ve explained how to get invalid data in routine body when using UNSIGNED data type and that in this case MySQL does not throw any exceptions.

One of the possible solutions of this problem is explicit setting of the NO_UNSIGNED_SUBTRACTION mode as it is shown in an example in the MySQL documentation.

Let’s modify a routine script:

(more…)

When working with databases it is always necessary to import data or schemas. In this article we describe the process of importing data from a text file into a MySQL database, and also we discuss questions concerning problems with MySQL import and the ways of solving these problems. We will give a detailed description of the Data Import tool of dbForge Studio for MySQL, describe the capabilities of this tool and illustrate its usage.

(more…)

This article gives a step-by-step instruction for visual database creation.
There is a lot of instruments that allow database developers avoid monotonous and error prone manual writing of scripts for tables creation. But to have a complete picture while creating a database it’s necessary not only to speed up the process of database objects creation, but also to visualize relations between them. dbForge Studio for MySQL offers a perfect tool for such purpose – Database Designer.

(more…)

In dbForge Studio for MySQL you can find Data Compare, a tool which allows you to compare and analyze tables data in databases, for example, to check that data in the synchronized databases are identical. Besides, it  allows synchronizing the data differences to get identical databases. The following picture illustrates comparison and synchronization of two MySQL databases.

Data Comparison Workflow

(more…)