Redgate Data Modeler will never let you get stuck in a data type dead end. Even if the type you need is not listed, it doesn’t mean you cannot use it. Data types you can find in the data types panel are just the most popular ones. Read more
Relationships in the real world may not be as easy as we would like them to be. Sometimes we want to model a situation where one table is refering to the other more than once. Luckily, with Redgate Data Modeler, this is a piece of cake. Read more
Sometimes the naming convention you use requires a specific pattern for the primary keys’ names. That’s why you may want to set your own names for each primary key in your database model instead of using default ones. Go on reading to get to know how to do this in Redgate Data Modeler. Read more
This has been a good year for Redgate customers. Major software releases of SQL Prompt, SQL Compare, Redgate Monitor, and SQL Source Control have introduced new features, added support for the latest versions of SQL Server Management Studio and Visual Studio, and made them even easier and more intuitive to use. Redgate Monitor v5,... Read more
You can comment on your database objects (tables, columns, views) in Redgate Data Modeler. You can also include this metadata in your database, where it can be accessed by your SQL developers or DBAs. Read more
Primary keys may contain more than one column. Multicolumn primary keys are frequently used for junction tables, which are used to model many-to-many relationships. Read more
Sometimes, you want all identifiers in your SQL script to be quoted. For example, you want them to have a particular case. Luckily, Redgate Data Modeler allows you to quote all SQL identifiers in your generated script to prevent you from any SQL name conflicts. Read more
Sometimes there are columns in a table that don’t belong to primary key, but are still unique. To mark them as a unique, you have to create an alternate (unique) key containing it. Read more
In this article we will show you how to design a database structure for an educational institution to store information about students, lecturers, classes, attendance, students’ achievements, etc. Read more
Did you know that you can copy tables between models in Redgate Data Modeler? It's useful for instance with tables that appear in almost every database model like user_account, address, client or product, or with tables that are specific for your domain. You don't have to create all tables from scratch. Read more
