Devart Blog

database diagram

Adapting Diagram File to Another Database

Posted by on October 19th, 2012

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server. (more…)

How To: Create a Database Diagram Using a Sketch Image

Posted by on October 5th, 2010

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

Question:
How to create a database diagram basing on the image available?

(more…)

Quick start in database development with Sakila database project

Posted by on August 12th, 2010

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.

(more…)

How to: Create MySQL Database in One Shot

Posted by on July 19th, 2010

This article gives a step-by-step instruction for visual database creation.
There is a lot of instruments that allow database developers avoid monotonous and error prone manual writing of scripts for tables creation. But to have a complete picture while creating a database it’s necessary not only to speed up the process of database objects creation, but also to visualize relations between them. dbForge Studio for MySQL offers a perfect tool for such purpose – Database Designer.

(more…)

How to: Create many-to-many table relationships

Posted by on June 18th, 2010

Many-to-many relationships between tables are accommodated in databases by means of junction tables. A junction table contains the primary key columns of the two tables you want to relate.

To create a many-to-many relationship between tables in dbForge Studio for MySQL:

(more…)

dbForge Studio for MySQL 4.00 Beta Treats MySQL Data like the Users Want

Posted by on December 11th, 2009

Devart today previewed dbForge Studio for MySQL 4.00, scheduled for release this December, and announced the immediate availability of a beta release that supplies database-dealing people with the very data management capabilities they want.

Having accumulated extensive knowledge in data management preferences and routines, Devart has created dbForge Studio for MySQL 4.00 Beta that predicts and delivers expected capabilities in any phase of dealing with data. The users can manage the data from soup to nuts in one place and with the same little effort as usual.

The highlights of dbForge Studio for MySQL 4.00 Beta include:

(more…)

Download a new build 3.50.305 of dbForge Studio for MySQL!

Posted by on June 23rd, 2009

Dear users,

Devart Development Team has released today a new build 3.50.305 of dbForge Studio for MySQL, which includes the following bug fixes:

(more…)

How To: Save Database Diagrams as an Image

Posted by on May 27th, 2009

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 can read more about it in Getting Started with Database Designer article.

Database Designer also can save a database diagram as an image.

Saving Database Diagram as an image

To save database diagram as an image, perform the following steps:

(more…)

Getting Started with Database Designer

Posted by on March 24th, 2009

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 Is Database Designer?

dbForge Studio for MySQL incorporates Database Designer — a powerful visual design tool for database development that allows you to build a clear and effective database structure visually and to see the complete picture representing all the tables, foreign key relations between them, views, and stored routines of your database on a database diagram.

(more…)

Roadmap: dbForge for MySQL

Posted by on December 4th, 2008

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

(more…)