Tag Archives: SQL Compare

Deploying Row Level Security with SQL Compare

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for some time, but we now have it on premise. It’s easy to setup and use, and worth taking a look … Continue reading

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

Deploying Dynamic Data Masking Changes

I wrote a short piece over on the Redgate blog that covers how SQL Compare can catch and build a script to move Dynamic Data Masking (DDM) code from one database to another. As the surface area of SQL Server … Continue reading

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

SQL Compare 12 Beta

The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve been involved in looking at some early designs and functionality, and have been waiting for the product to get to … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was testing some type of deployment scenario, and didn’t want to drop the database, but rather just remove objects and redeploy. … Continue reading

Posted in Blog | Tagged , , ,

Building Rollback Scripts with SQL Compare

There’s a neat switch in SQL Compare that lets you build rollback scripts. It looks like this: I’ve used this before to help with deployments, as many of you have. The idea is that when you finish with your code … Continue reading

Posted in Blog | Tagged , , ,

Excluding Schemas in SQL Compare

I saw this question posted the other day and thought it was a great idea. I haven’t been a big schema user in the past, but I see the value of excluding some schemas. CDC for sure, but I know … Continue reading

Posted in Blog | Tagged , ,