studio for mysql

New Shiny Badges on dbForge Studios’ Award Wall

The accolades for our dbForge Studios just keep coming!  Today we are immensely proud to announce that we received an array of major awards from the Crozdesk platform.

(more…)

How to Connect to MySQL Server Databases Remotely

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicated server that can deliver the required level of security and performance. With the help of root/sudo user privileges, you can enable new remote connections and set up secure and effective teamwork with your databases using a remote MySQL server.

(more…)

dbForge Studio for MySQL vs MySQL Workbench

Every single year new products and new versions of the leading tools enter the market. Their providers compete, offering database specialists more and more features. Thus, users have a whole bunch of possibilities to achieve their goals with the best-fit solutions. The only challenge remaining is which tool to use.  (more…)

MySQL Primary Key: CREATE and ALTER TABLE Statements

Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for Data Quality and proper relational database design. In this tutorial, we provide background information on Primary Keys and their function as well as give code examples to illustrate the theory.

(more…)

Data Export from Amazon RDS MySQL Instance

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for backup, etc. The fact that data are usually required yesterday and export tasks need to be repeated again and again only compounds the difficulty. This article presents a walkthrough on how to export data quickly and easily with the help of dbForge Studio for MySQL.

(more…)

How to Convert MySQL Data to PostgreSQL

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

(more…)

How to Create Tables Using MySQL CREATE TABLE Statement in dbForge Studio for MySQL

There are two main ways of creating tables in MySQL databases:

(more…)

How to Create a Many-to-Many Relationship

Establishing a many-to-many relationship between the tables in a database is usually done for ensuring efficient data processing and data integrity, as well as for database normalization and data analysis tasks.

(more…)

Data migration from MySQL to Oracle server

Data migration is a tiresome task requiring a great deal of manual activity. In this article, we will examine how to migrate MySQL data to the Oracle server, using Data Export feature built-in dbForge for MySQL products. In the given worked example, we will move data from the actor table and the query result from the sakila database that exist on MySQL server to the SCOTT schema on Oracle server.

(more…)

How to kill certain connections to a MySQL database

Maintenance of databases or servers is quite often performed by database administrators at night. But these routines sometimes get blocked by long-running queries or applications that hang onto locks much longer than expected.

(more…)