Data Modeling Made Easy using ER/Studio Data Architect

How to Create a Simple Data Model Using IDERA ER/Studio

Today we will be taking a look on how to create a simple Data model using IDERA’s Flagship Data Modeling tool, IDERA ER/Studio Data Architect.

The purpose of reverse engineering a database is to help you better understand the underlying database schema.

Objects Retrieved Through Reverse Engineering

Reverse engineering a database can bring back some of the following object types:

• Tables
• Views
• Stored Procedures
• Triggers
• User-Defined Objects
• Materialized Views
• Storage Objects

Reverse Engineering an Existing Database: Step-by-Step Guide

In this tutorial, we will show you how to reverse engineer from an existing Database.

Start the Reverse Engineering Process:

• • Click on File → New and choose Reverse Engineer and Existing Database.

Click on the Login button.

Select the Database:

• • We will reverse engineering the AdventureWorks LT Database.

Configure Connection Settings:

• • Choose Native connection, enter your server information, and click Next.

Choosing and Importing the Database Objects

• Click on the Database List ellipse button and select AdventureWorksLT from the list.
• (Optional) Download SQL Server samples from the provided website if needed.
• After selecting the database and schema, choose the objects you wish to import.

Click Next to proceed.

Now pick the objects you wish to bring back.

Inferring Relationships and Completing Reverse Engineering

Click Next to see if you wish to infer any relationships via:

1. Primary Keys
2. Foreign Keys
3. Foreign key names from Indexes

Once you are satisfied, pick the Circular Model Option, which is the first Diagram Layout button, and click Finish to kick-start the Reverse Engineering.

And there you go folks! A successful reverse engineering process of your database.

Feel free to download a free trial.