How To

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.

Database Designer presents the database that is being created in the form of a database diagram. Database Designer tool available in dbForge Studio for MySQL serves for creating databases visually.

This article will open a series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the...

Database development is not limited to an initial copy of a database. On your road you meet multiple enhancements, refactoring, upgrade and many other...

Introducing Enumeration support in databases Enumerations support in LINQ to SQL Case management Entity Developer User interface for enumerations Creating enumerations Naming rules ...