DZone

In this article, I’ll demonstrate how to use SQL Change Automation, a PowerShell script, to take the contents of a source control directory for a database, check that it is possible to build from it, document it, and then create a NuGet package and place the code in it along with the documentation. Finally, I’ll show how to synchronize the database schema of an existing database so that it matches the schema of the source control version that we just built and validated.

I’m on the liberal wing of opinion about how to do database delivery as part of the application. No sooner does one person decide on the royal road to stress-free database delivery, someone else comes up with a wildly different idea that is just as successful. Tools that assist with this process have become a lot more flexible to use, and SQL Change Automation (SCA) is typical of this trend, having evolved from DLM Automation suite by adding support for migration-based development.

Source: DZone