![]() ![]() ![]() SCA is a plug-in for Visual Studio that creates a new SQL Change Automation project type. ![]() This will be a Brownfield development project, to upgrade an existing database, so you’ll need a SQL Server instance and database with existing objects (creation script for my sample database is here) Creating a Project SQL Server Management Studio is optional as the SQL Server Object Explorer in Visual Studio can be used instead. ![]() Visual Studio installed (VS 2017 used here) with the SQL Change Automation pluginĪ version control system is highly recommended, and this article will use Git, but any version control system compatible with Visual Studio will work.There are a couple of requirements to follow along with this tutorial: In this article, the first in a short series, I’ll show you how a team can use SQL Change Automation in Visual Studio to do development work on an existing database. SQL Change Automation (SCA) is a tool designed to help you automate and optimize the way you develop, build, test, and release SQL Server databases, including integration with source control. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |