SQL Compare

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

T-SQL Tuesday 153: The conference that changed everything

By

This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...

T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily

By

Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...

Power BI guidance documentation

By

Recently there has been a number of great articles published on Power BI that...

Read the latest Blogs

Forums

Is Your Vehicle Suspension System Faulty? Here’s How To Fix It

By carolynbaker658

Generally, people buy cars for their comfort while commuting to work as well as...

Consistent Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Consistent Time

Help with Copying backup files and capture results in output file with details

By SQLisAwe5oMe

Hi Team - I have the below PowerShell script which is working for me...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers