Redgate Data Modeler internally stores your model in an XML format. You can download the XML file and use it to extract some information by using a script. Let’s take a look at the structure of this XML file.Read more
Sssshhh. There’s a revolution going on. Quietly, purposefully, and without fanfare, Database Lifecycle Management is looming on the horizon for every developer and DBA. A continuous, agile-based approach to integrating, coordinating and managing the different phases of database delivery. Whoah, there. Database Lifecycle Management? Application Lifecycle Management, yes, but how…Read more
We’ve been working on a new product that involves writing Windows PowerShell cmdlets (pronounced “commandlets”) for our customers to use and, to make their lives easy, we want to provide rich built-in help documentation. There’s no easy way to do this out of the box, so I’ve written a tool…Read more
The Redgate Data Modeler journey continues … We now have almost 10,000 users and the number of Redgate Data Modeler advocates keeps growing strong.
Redgate Data Modeler users come from over 100 countries and speak various languages. What unites them?
The relational database.Read more
Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy.
Read more
The “extended” UX team sharpening their swords… At Redgate, our software engineers run regular “code katas”, workshops where developers practise their coding skills on simple problems, then discuss the experience afterwards as a learning exercise. So, a while ago, I thought it might be a good idea to use the…Read more
UML is popular for its notations. We all know that UML is for visualizing, specifying, and documenting the components of software and non software systems. What's more, UML has many types of diagrams which are divided into two categories. Some types represent structural information, others general types of behavior. Among…Read more
IDEF1X is a method for designing relational databases with a syntax that supports constructs in developing conceptual schema. Not everyone knows that this notation has an interesting history. Indeed, the need for semantic data models was first recognized by the U.S. Air Force in the mid-1970s. Let's take a closer…Read more
Continuing our trip through different ERD notations, let's review the Chen ERD notation.
Peter Chen, who developed entity-relationship modeling and published his work in 1976, was one of the pioneers of using the entity relationship concepts in software and information system modeling and design. The Chen ERD notation is still…Read more