How To

With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.

This article describes how to set up table data comparison by help of Oracle package and synchronize data in case of differences.

The article describes such ways of data synchronization of Oracle databases as Advanced Replication, Oracle Streams, GoldenGate. Also it gives a brief comparison of shortcomings and benefits of each way for data comparison and synchronization tasks when developing and testing databases.

When you perform data maintenance operations, sometimes, it's necessary to disable or enable all foreign keys in the user schema. Here is the script that...

In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.

The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.

Making database backups is one of the most important things in the process of administrating MySQL databases, because some critical data loss can be irreplaceable. To avoid data loss you should make backups of all active databases regularly. If you have a backup, you will be able to restore the whole database or some of its objects easily.

In this article we continue series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the...

This article explains how to kill users' sessions before recreating Oracle schemas.

Making a backup copy of a large database takes a lot of time. Besides, MySQL database import and export implies transferring a large amount of data between client and server. This article covers these and a few other questions in light of effective work of MySQL administrator.