MySQL

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by...

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.

This article describes the options offered by Data Import Wizard of dbForge Studio for MySQL for importing data from text files.

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.

Entity Framework 4 RC allows you to create and drop databases in run-time using SSDL for DDL generation. Now ObjectContext has CreateDatabase(), DropDatabase(), and...

We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for...

Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...

Article was updated on 3/4/2010 This article can be useful for programmers who want to develop cross-database applications and use the canonical functions. Entity Framework Canonical...

Devart announced the release of dbForge Query Builder for MySQL v 1.10, a professional tool for quick creation of any queries without code and...

Devart has released today the updated version 3.50 of dbForge Fusion for MySQL - a powerful add-in for Microsoft Visual Studio, designed to simplify...

Introduction MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions. Stored procedures are a set of SQL commands...

dbForge Studio for MySQL has the Database Designer functionality that allows you to build and view the structure of your database using the diagrams. You...

If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature....

Contents What Is Database Designer? How to Create a Database Diagram Navigating the Diagram How to Quickly Print Diagram Saving and Restoring the Diagram What...

Devart company decided to publish roadmap of dbForge for MySQL line to help you understand the future product development. This roadmad encompasses two products:...

How to compare and synchronize MySQL views? Recently we discovered some tricks in schema synchronization process of MySQL databases. It's about how MySQL creates...