Tag Archives: Data Modeler

Changing the Cardinality of a FK in Redgate Data Modeler

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

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

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

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 , , , | Comments Off on Using SQL Compare with Redgate Data Modeler