Tag Archives: Redgate

Redgate SQL Data Masker Refreshing Schema

Posted on November 4, 2020 by way0utwest

This is a quick blog to help me remember what is going on with the Data Masker product. This is for the SQL Server version, but I believe the Oracle one is very similar. I added a new column to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Redgate SQL Data Masker Refreshing Schema

A Limited User for SQL Data Catalog

Posted on October 12, 2020 by way0utwest

One of the things I’ve pushed for at Redgate is to document the minimum permissions needed for our products inside a database. Often this isn’t possible as some of our products require sysadmin, but some don’t. I was resetting Data … Continue reading →

Posted in Blog | Tagged | Comments Off on A Limited User for SQL Data Catalog

Adding ApplicationIntent=readonly to SQL Data Compare

Posted on September 14, 2020 by way0utwest

Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from production systems, load is a concern. With Availability Groups (AG), we … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding ApplicationIntent=readonly to SQL Data Compare

Exchanging Schemas with SQL Compare Snapshots

Posted on August 26, 2020 by way0utwest

Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and that’s one reason we have SQL Compare snapshots. Here’s a quick … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Exchanging Schemas with SQL Compare Snapshots