VSTS | TFS 2018 | TFS 2017 | TFS 2015
Here we’ll show you how to define your continuous integration (CI) process for your SQL server database project.
Get set up
For the instructions in this topic, you need a SQL server database project in Visual Studio.
If you don’t yet have an app but want to try this out, then see the Q&A below.
Define your CI build process
Create the build definition
- Select the .NET Desktop template.
- As the repository source, select the team project, repository, and branch.
Enable continuous integration (CI)
On the Triggers tab, enable continuous integration (CI). This tells the system to queue a build whenever someone on your team commits or checks in new code.
Queue and test the build
Save the build definition and queue a new build by selecting the Queue new build command. Once the build is done, click Artifacts and then Explore to see the DACPAC (.dacpac file) produced by the build. This is the package that your release definition will consume to deploy your database.
Deploy your database
After you’ve run the build, you’re ready to create a release definition to deploy your database to:
How do I create an SQL server database solution?
In Visual Studio, connect to your team project.
On the Team Explorer home page (Keyboard: Ctrl + 0, H), under Solutions, click New.
Select the SQL Server templates section, and then choose the SQL Server Database Project template.
I use TFS on-premises and I don’t see some of these features. Why not?