Our company has been working on its own MySQL GUI client development for over 6 years. Many features were implemented in this product in accordance with our users’ requests, that acted as task originators for us. We are glad that the development process of our MySQL Front-End goes on and on, and we were able to release version 5.0 of the product. For the release of version 5.0, we decided to make a special video telling about the product history. You can see the result.

Funny video about history of our MySQL GUI tool

We did not intend to have a professional video made by clip-makers. The video was shot frame-by-frame using a common digital camera. After that jpg files were rendered to the mp4 video format. Shooting took almost 7 hours. All models were made by hand from plasticine by one of our employees, whose hobby is design and model-making. All of us want to thank him for this!

A comma-separated values (CSV) file is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. CSV file is a text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next with a comma. For example, a CSV file might be used to transfer information from a database to a spreadsheet or another database. Of course, there are more advanced formats to store data, for example, XML, but CSV does have one advantage over XML. CSV has much lower overhead, thereby using much less bandwidth and storage than XML.

Now let’s analyse how one can save data from a MySQL table to a CSV file.

Read the rest of this entry »

In the new version we made a lot of improvements and added a whole pack of new features in almost all dbForge Studio’s tools. And the most remarkable thing about this release is that nearly all novelties were suggested by our users. So we hope they will enjoy working with the new version and feel that they have contributed a lot to make it as it is.

Cutting-Edge MySQL GUI Client: dbForge Studio for MySQL

With the help of our users we could work on the product on the new level, and as a result of such successful tight cooperation its standard of quality grew. This new standard includes taking into account actual needs of people using our product and implementing their exact requirements except studying the market in general and implementing features that are theoretically demanded.

When you open the application to get acquainted with the new version, you will be surely stunned and pleasantly surprised by its new look. When you start using it, we hope you will be thrilled by the inner improvements and make the best use of them:
Read the rest of this entry »

Changes (as compared to 4.50.339) include:
Bug fixes:
* The error on entering selection criteria after selecting Group By fields in Query Builder fixed (T26884)
* The problem with showing 0 as a parameter value instead of NULL in the parameter editor fixed (T26867)
* Removing field’s autoincrement sign on adding index in the table fixed (T24859)
* Extra new line on copying data from a cell in Data Editor removed (T27021)
* The problem with losing ON UPDATE CURRENT_TIMESTAMP during editing a table fixed (T27090)
* The problems with connecting to MySQL Server via SSH tunnel fixed (T26911, T20079)
* InvalidOperationExceptions on generating schema synchronization script in the Schema Comparison tool fixed (T27106, T27108)

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

When developing databases, we frequently need to check what changes were made to its schema, if any mistakes were made, and, if there are any, we should roll back to the working version saved in the source control system. To do this, it’s enough to compare schemas of version 1.1 and 1.2, and generate an UPDATE SCRIPT using any Database Diff tool.

So what functionality should be available in such tool?

Firstly, the tool should be easy-to-use and user-friendly. A user should not be obliged to learn a pile of topics in the tool documentation before using it. It should be enough to perform the following set of steps:
1) Select Source and Target
2) Select a schema or several schemas (if the tool provides such possibility) for comparison
3) Tune comparison process by checking the needed options (an optional step)
4) View comparison results
5) Tune script generation options (an optional step)
6) Generate an update script and/or execute it directly to the target database
Secondly, the tool should support comparison of all object types you might have in your schemas – otherwise, how the tool is supposed to look for differences in them? And, at last, the tool should be fast. This point is especially important for searching data differences, when comparison of several schemas is performed, or the size of the project itself is large.

Now let’s look at some tools offering schema comparison functionality.
Read the rest of this entry »

MySQL has advanced database access system. A database user can have access to the whole database, separate tables, or to separate columns of tables. Also there is a restriction for actions a user may perform with records. MySQL server uses several tables in a special database to organize such a complicated database access structure. The access policy is based on the values available in these tables.

The database that MySQL server uses to store internal data about users is called mysql by default. There are tables for storing information about users’ accounts in this database:
Read the rest of this entry »

This article is a step-by-step instruction for configuring Oracle Instant Client so that our tools for Oracle could work with it.

Read the rest of this entry »

In the previous article we told that we’ve performed a lot of work concerning optimization of parsing queries in SQL documents. Also we informed that we’ve fixed all problems that were found by users of our intellisense… But recently one user sent us quite a small script that caused freezing of SSMS by Devart SQL Complete. Here it is:
Read the rest of this entry »

Having successfully released our data comparison tool for Oracle we went further by starting the new one. dbForge Schema compare for Oracle is targeted to help database developers perform sustainable change management process. The tool is designed to:

• compare Oracle schemes
• analyse changes between databases
• generate schema comparison reports
• synchronize databases immediately or save sync scripts for later use

In order to allow our users make changes and improve product even before the first release we decided to publish early access preview of the dbForge Schema Compare for Oracle.

Visit product page http://www.devart.com/dbforge/oracle/schemacompare/ download product and leave us a feedback.

Recently we have released a free SQL Complete tool that provides IntelliSense and script layout for SQL Server. If you like IntelliSense in Visual Studio and write T-SQL, you’ll probably appreciate the productivity improvements with SQL Complete.
Read the rest of this entry »