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

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

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

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

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

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

Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data – json data type in MySQL (since MySQL 5.7.8), and json and jsonb data types in PostgreSQL (json introduced in PostgreSQL 9.2, and jsonb introduced in PostgreSQL 9.4). (more…)

A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a particular database server. This article will help you to cope with usage of collation in MySQL to control case sensitivity settings in generated queries. (more…)

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

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