Tag Archives: Data Modeler

A Redgate Data Modeler Gotcha with Relationships

Posted on May 4, 2026 by way0utwest

This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read on to see what happened and what I did. This is … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Changing the Cardinality of a FK in Redgate Data Modeler

Posted on April 13, 2026 by way0utwest

One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this  easy, and this post will show you how. This is part of … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Setting FK Constraints in Data Modeler

Posted on February 11, 2026 by way0utwest

One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy, but they encountered a few errors. Here is how this worked … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Deploying an Updated Model with SQL Compare 16

Posted on January 28, 2026 by way0utwest

In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this post, I want to update my model, and again use SQL … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Deploying an Updated Model with SQL Compare 16