sql change automation

External Article

Using Filters to Fine-tune Redgate Database Deployments

  • Article

Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.

2020-09-02

External Article

Introducing SQL Change Automation 4.3

  • Article

The latest version of SQL Change Automation now integrates with SQL Clone to let you use a snapshot of your database’s schema as a baseline. This simplifies migration development in complex databases, avoiding problems like invalid objects or circular dependencies, and you can verify migration scripts on a copy of the currently released database.

2020-08-20

External Article

6 New Courses Published on the Redgate University

  • Article

Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!

2020-07-17

External Article

Allowing for manual checks and changes during database deployments

  • Article

SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.

2020-06-15

External Article

New release: SQL Change Automation 4.1

  • Article

We’ve heard from users that they really care about static data and were missing the feature in the SQL Change Automation SSMS plugin. In v4.1, we’ve added support for the tracking of static data tables to the SSMS extension, alongside existing support in the VS extension. Maya Malakova has written a technical summary showing how to use this feature. Learn more about the release here.

2020-01-21

Blogs

AI Step 1

By

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

By

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

identify consecutive records greater than 1

By HeftSteady

Hello I need help identifying all records that have consecutive hours (time in order)...

Call dynamic sql storedprocedure from SSIS execute sql task

By komal145

hi, I have a table called Rules Create table Rules ( Id int ,...

Migrating database with many orphan users.

By JasonO

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query? 

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013;

See possible answers