Tag Archives: Data Modeler

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 , , | Leave a comment

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 , , , | Leave a comment

Using SQL Compare with Redgate Data Modeler

Posted on January 22, 2026 by way0utwest

Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take a model and compare it to a database, and deploy my … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

Setting PK Names in Redgate Data Modeler

Posted on January 12, 2026 by way0utwest

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names. I had to test and discover if I could make things better, and I could. This post shows how. This is part of a series on … Continue reading →

Posted in Blog | Tagged , , | Leave a comment