Database Continuous Integration and Delivery (CI/CD) using Azure devops – Part 1

Using SSDT, we can create a database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project. This makes your database code, procedures to be under source controlled and can be managed to deploy through CI/CD pipeline.

Output of the SSDT project is a DACPAC file. DACPAC is Data Tier Application Package. Its a logical database management entity that contains database model like tables, views, and instance objects. Generated DACPAC file can be deployed to multiple environments.

I will explain the continuous integration and continuous delivery of the database project.

Creating the Project

  • Create a new SQL Server Database project in Visual Studio

create project

  • Import the existing database.

  • Provide the database server details

  • Leave the other settings as they are and click start.

 

  • After a few seconds the import should be complete.

 

  • The database tables and procedures are successfully imported.


  • Once you build the project, you will able to see .dacpac file created in bin folder.

There is Database Continuous Integration and Delivery (CI/CD) using Azure devops – Part 2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s