SQL Compare

SQL Compare

How to build multiple database versions from the same source: object filters

I’ve worked with several companies who maintain databases in multiple data centers, each one holding the data for a particular region, and each database serving multiple applications. Over time, for various business or legal reasons, it often becomes necessary to apply updates to certain individual data centers. The right, but hard, way to do this Read more

SQL Compare

How to compare two DacPacs using SQL Compare

Often during my development work, especially at the Proof-of-Concept (PoC) stage, I need a quick and easy way to save my current progress, for example, by updating a set of object build scripts in a directory. Ultimately, I also need a way to compare my current development database or script directory to a target production Read more

SQL Compare

How to automate database synchronization using the SQL Compare command line

As a database developer, I use SQL Compare extensively during the Proof-of-Concept (PoC) phase of my projects, when I’m trying out new ideas and developing code on my local machine. I need to start from an up-to-date database schema from the production database, and have a simple way to keep track of my database schema Read more

SQL Compare

How to create a directory of object-level scripts using SQL Compare

In this simple ‘how to’ article, I’ll explain why it’s often useful to be able to create a directory of object-level scripts from an existing database, and then how to create that directory of scripts using SQL Compare. For each object in the database there will be one object build file (*.sql). The scripts will Read more

SQL Compare

Using SQL Compare with In-Memory OLTP tables

If you’ve read my simple assessment of SQL Server’s In-Memory OLTP tables on Simple-Talk and have decided to implement them, we’re in a position to support your move. Redgate SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively compiled procedures, and generate the appropriate scripts. Read more

SQL Compare

Using SQL Compare with Row Level Security

SQL Server 2016 brings with it a host of new features that will be both useful and appreciated by many customers. Quite a few of these features relate to providing additional security for databases, one of which is Row Level Security (RLS). This is a feature that has been available in Azure SQL Databases for Read more

SQL Compare

Using SQL Compare with Dynamic Data Masking

One of the features that I hear many DBAs excited about in SQL Server 2016 is Dynamic Data Masking (DDM). This allows DBAs to centrally set a mask that is returned for a table column instead of the actual data. This means an application that wants to limit what information is returned to certain users Read more