SQL Change Automation

External Article

Simple Database Development with SQL Change Automation

  • Article

SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts and object-level scripts, for every version of the database.

2020-07-08

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

Static data in SQL Change Automation SSMS plugin

  • Article

Kendra Little sat down with the SQL Change Automation Dev Team to get some insight into how they build the product with the customers in mind. SQL Change Automation 4.1 included adding support for the tracking of static data tables to the SSMS extension. This was a direct result of the communication and work the team have carried out with their customer base. Read Kendra’s blog to find out more about the release and the work that goes into delivering these updates.

2020-02-04

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

External Article

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

  • Article

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

2019-12-13

External Article

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

  • Article

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

2019-12-10

Blogs

Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose

By

In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...

Daily Coping 12 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Read the latest Blogs

Forums

Help me design a correct simple table

By freiza

I have a table like Diesel(id, supplier, operator, machine, taken_time, given_time) There are 2...

Error Grafana SQLWATCH

By abdalah.mehdoini

hello , I am looking for a Grafana expert to help me with this...

SQL Standard Confusion

By Phil Factor

Comments posted to this topic are about the item SQL Standard Confusion

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers