SQL Change Automation

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

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

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

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

Daily Coping 4 Jun 2020

By

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

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

Marketing Your Brand On Pinterest

By alexrory4650

Strategic Ways to Use Marketing Your Brand On Pinterest. Make sheets with watchwords in...

Database Extended Properties

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Extended Properties

Date Join Issue

By nymets86

I joined two tables together trying to get a field out of one and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers