July, 2009

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

Devart has released today the updated version 3.50 of dbForge Fusion for MySQL – a powerful add-in for Microsoft Visual Studio or CodeGear RAD Studio, designed to simplify MySQL database development and enhance data management.

Up to 100 usability improvements have been implemented, so you get better insight and satisfaction as well as a total control over performed tasks through the modernized UI of dbForge Fusion for MySQL.

Striving to speed up performed tasks, dbForge Fusion offers compression to reduce traffic, while exchanging data with MySQL server, and makes the exchange quicker.

The new features of dbForge Fusion for MySQL 3.50 include:

(more…)

Recently, we were updating our own database used for dbForge Data Compare for MySQL testing. I wanted to add several tables with data, using a dump file of one of the tables.

Problem
But how to drop a millisecond part in every pasted string, I mean a date like ‘2006-12-24 15:35:19.658′ should be replaced with ’2006-12-24 15:35:19′ one?

Any simple Find and Replace functionality won’t help, as I don’t know what to find and with what to replace.

Solution

(more…)