MySQL Tools

Extended Connectivity in dbForge Tools for MySQL

We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL, dbForge Query Builder for MySQL, dbForge Data Generator for MySQL, and dbForge Documenter for MySQL. (more…)

Eight Supported by Eighth!

We would like to take this moment to thank the Oracle company for continuous development of the popular MySQL database! As you all might know, Oracle has recently released  MySQL Server, v8.0. In its turn, Devart decided to get a move on and release the new dbForge Studio for MySQL, 8.0! (more…)

MySQL Documenting Has Never Been Easier!

We just love to make our users’ life a bit easier. This time, we are excited to treat you with a brand new addition to our dbForge for MySQL product line, – dbForge Documenter for MySQL. (more…)

Reinvented dbForge Tools for MySQL Have Arrived!

After a grand update of dbForge Studio for MySQL, we haven’t forgotten about the rest of the dbForge for MySQL product range. Our developers took maximum care of each and every MySQL tool and revamped them with specific new features and updates. (more…)

No one has ever imagined dbForge would do it to Google Sheets!

”Wow!’, ”Cool!’, “Fantastic!”, “A revelation!” – this was the first reaction of our colleagues when we presented fresh dbForge Studio for MySQL, v7.4 to them. Indeed, our team has done a huge work in to meet our customers’ needs and expectations. (more…)

How To Import a .CSV file through the Command Line

In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio for MySQL.

(more…)

Using HTTP Tunneling

Summary

This article elaborates on the HTTP Tunneling connection method and explains how to configure it by means of dbForge Studio for MySQL.

Introducing HTTP Tunneling

HTTP tunneling is a method of connecting to a MySQL Server through HTTP/HTTPS protocol and via the port that is used by a web server. The method may come  in useful when a direct connection to MySQL Server, that utilizes port 3306, is problematic for certain reasons, e.g. it is closed by security reasons, or firewall blocks access from all network protocols, except HTTP. Since port 80, that is used by web server, cannot be blocked, HTTP tunneling seems to be the ultimate technique to solve a range of MySQL connection issues.

(more…)

How To: Automatically Email Comparison Report

dbForge Studio for MySQL allows you to automate report creation process by using command line utility. There is a simple way to send comparison reports automatically via email.

To accomplish this task we will use the Collaboration Data Objects (CDO), previously known as OLE Messaging or Active Messaging. CDO is an application programming interface included with Microsoft Windows.

Below is the simple BAT file that automatically saves a comparison report in the HTML format on the “D:\\” drive and runs the send.vbs script file.

call “C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com” /datacompare /compfile:d:\project.dcomp /reportformat:HTML /report:d:\report.html
start send.vbs

(more…)

Special Aspects of Sphinx SE Support

At the moment, dbForge Studio for MySQL allows you to create a connection to Sphinx Search Engine. Due to technical restrictions, a warning message appears in some cases. The reason the message appears is because, there is no possibility to define that the connection happens to  Sphinx SE. We requested the Sphinx SE developers team to fix this problem.

 

When the warning message appears?

Case 1: When you create a connection to Sphinx Search Engine, the message appears for the first time.

Case 2: The same message appears when you create a new SQL document. It appears only once and doesn’t repeat for other new SQL documents.

Case 3: The message appears when you click a Sphinx SE connection in Database Explorer.

Warning message

Warning message

In any of these cases, just click OK, and continue your work.

(more…)

How To: Convert a Database from Microsoft Access to MySQL

The current version of dbForge Studio for MySQL does not allow to import the whole Access database at once. Instead, there is an option to migrate separate Access tables in MySQL format.

The article below describes the entire process of converting Microsoft Access tables to MySQL.

(more…)