October, 2010

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

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to the new version was synchronization of the LOB data. When we developed the first release of the product we postponed this feature because of challenges of synchronizing LOB data. These challenges caused by nature of data stored in BLOB or CLOB columns. It’s large and simply does not fit into SQL script. But we’ve found the solution.

In this article we will examine basic methods of loading LOB data into a table.

(more…)

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…)