sql change automation

Data and database management in everchanging technology landscape

• by Roopesh Uniyal

• SQLServerCentral

• Uncategorized

• Article

This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

Log in or register to rate

You rated this post out of 5. Change rating

2022-03-23

1,124 reads

• Discuss

Win DevOps books with Redgate’s competition

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Redgate is giving you the chance to win your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’

2021-05-17

Moving from application automation to true DevOps by including the database

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.

2021-04-08

Database Build Blockers: Four-part Object References

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms.

2020-12-24

Database Updates: Rolling Back and Fixing Forward

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.

2020-12-11

Using Filters to Fine-tune Redgate Database Deployments

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• 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

Introducing SQL Change Automation 4.3

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• 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

6 New Courses Published on the Redgate University

• by Additional Articles

• Redgate

• learning

• 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

Allowing for manual checks and changes during database deployments

• by Additional Articles

• Redgate

• SQL Change Automation

• 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

New release: SQL Change Automation 4.1

• by Additional Articles

• Redgate

• SQL Change Automation

• 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