Contact Us

Reverse Database Engineering and Database Design

Reverse Database Engineering Can Expedite Database Design By Far

Hi everyone, We are the Farber Consulting Group Inc. We provide database design New York, Remote DBA and custom software development services. Today we will be talking about reverse database engineering, hope you enjoy the video.

Call us for Free Consultation for Remote DBA services at our SQL Consulting Firm at: 732-536-4765

Reverse database engineering is a very powerful feature found in data modelling tools. We have been using it for 18 years with xCase which also handles an assortment of databases such as MS SQL MySQL Oracle, Ms Access, Visual FoxPro and much more…

In many cases, we have an existing database but don’t have the original E-R diagram or physical model. Reverse Database Engineering allows us to reconstruct a physical and/or ER model from an existing schema.

Reverse Database Engineering can be used to:

  • Provide documentation on an existing application.
  • Provide the developer with a better overall picture of the schema.
  • And really save significant time by bringing the entire schema right under your fingertips.

Reverse database engineering is extremely useful for tracking down the Foreign Key relationships, Primary Keys and all indexes, stored procedures, Triggers and Views.

Here is the video to demonstrate Reverse Database Engineering:

See below how the Entity looks like when double click on it:

Data Modelling Tool to perform Reverse Database Engineering services that includes: Remote DBA, SQL Consulting and Custom Software Development Services and Database Design.

Check our Custom Software Development Services.

Below is a snippet from one of our models done with xCase data modelling tool.

Each dotted line between one entities to another represents a relation between entities. As shown in the image below, a relation is defined when a dotted line coming out say from the Names Entity as an orange line towards the Address entity. This is how we recognize parent child relationships. In this example the Address is the child of the Names entity. In a database design New Jersey, relationships between tables are part of the actual design process.

The process of Reverse Database Engineering is the staring point from an old database system to bring it right into our data modelling tool. Check our services for database design and Remote DBA services. Call us at: 732-536-4765

Go Back to Our: Main Blog

Written by: Doron Farber - The Farber Consulting Group, Inc

There are 7 comments for "Reverse Database Engineering and Database Design"

avatar
By Brian McKillop | June 28,2015

It's always a challenge picking up an existing system and trying to make head from tail.

A tool like this in the right hands is an invaluable time-saver.

Well done!

Reply
avatar
By Dave Mason | June 29,2015

Very interesting. Could save many hours and wrong turns.

Thanks.

Reply
avatar
By Sotiris Filippidis | June 29,2015

When dealing with complex databases, it's essential to have good documentation. The "code-first" trend does not mean that databases should be a black box, optimizations are always possible. So reverse engineering is absolutely useful. Good one.

Reply
avatar
By Denis Gavrikov | June 29,2015

Reverse Database Engineering is a major time saver especially if you happen to have new system with no database specifications.

Thanks for sharing

Reply
avatar
By Alan Sawyer | July 10,2015

Could save time for sure.

Reply
avatar
By Yaroslav Kazmin | July 10,2015

Yeah, it's definitely allows to understand better the structure and relationships between database objects and avoid huge problems in the future.

Reply
avatar
By John Willems | July 13,2015

There are many ways to design or code things. Over year 'best practices' change. So when working with someone else's data design its important to understand it. Reverse engineering is so useful and in the end can save hours. A nice addition to the developer community.

Reply

Add your comment