MySQL Tools

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.

(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.

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

MySQL WorkBench Worthy Alternative – dbForge Studio for MySQL

Did you know that dbForge Studio for MySQL is a great alternative to MySQL Workbench? In case you have used MySQL Workbench in the past, or consider using it now, you might want to take a closer look at dbForge Studio for MySQL, to make sure you pick wisely the tool that will meet your requirements the best.

(more…)

Adapting Diagram File to Another Database

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server. (more…)

Workaround for ‘Authentication failed’ Issue When Connecting through HTTP Tunnel

Some of our users have encountered problems with establishing a connection over the tunnel.php script despite the fact that the tunnel.php script is installed correctly. The following error message occurs: (more…)

Mind data modifications via Data Editor in dbForge Studio for MySQL

Since one of our users has encountered a problem when modifying data via Data Editor, we decided to bring such a situation to our users’ attention.

(more…)

MySQL Debugging Methods Overview

Introduction
Debugging SQL code is a very important task these days. Unfortunately not all database servers support this feature. And MySQL is one of such servers. In spite of its wide feature set, debugging is not implemented in it. So the problem is that MySQL provides no API functionalities for code debugging. But the necessity to debug SQL code does not disappear and becomes more and more important each year. Some companies that develop tools to access data of MySQL server databases create their own debuggers that solve this problem to some extent.

(more…)

2011 DevProConnections nominates dbForge Studio for MySQL as Best IDE Product!

dbForge Studio for MySQL - Best IDE Product

dbForge Studio for MySQL – Best IDE Product

Support Your Favorite Devart Products in 2011 DevProConnections Voting!

We would like to invite you to take part in 2011 DevProConnections
voting. The Community Choice Awards, as presented by Windows IT Pro, SQL Server
Magazine, and DevProConnections, allow you to decide, which IT products get chosen
for acclaim and recognition. This year Devart dbForge Studio for MySQL
is nominated in the following category.

2011 DevProConnections Community Choice Awards:

Category 14 (page 2): Best IDE Product – dbForge Studio for MySQL