Unit Testing for SQL Server Database in DevOps process
⚡ In this part of the video, we’ll look into how specifically dbForge Unit Test takes part in the development process. Execution of unit tests is one of the most important stages in the database DevOps process because it guarantees that all changes committed by developers to the database project will be verified and and that all functionality will continue working properly after the database is deployed.
Before including unit tests to the DevOps testing process, they first need to be created. You can do it with the help of dbForge Unit Test. This tool also enables you to execute these tests during the CI process.
ℹ️ Including dbForge Unit Test into the DevOps process. The following conditions are necessary for unit test execution:
📍 the tSQLt framework is installed in the database you need to test;
📍 unit tests are present in this database;
You can install the tSQLt framework with the help of the dbForge Unit Test tool for the database on which unit tests will be executed.
dbForge Unit Test provides a convenient interface for creating new tests and modifying existing ones.
Check more useful information:
🔥 How dbForge Unit Test is involved in the DevOps process here:
https://www.devart.com/dbforge/sql/database-devops/unit-testing.html
🔥 DevOps Automation is a part of SQL Tools:
https://www.devart.com/dbforge/sql/database-devops/download.html
✅ Subscribe to our channel https://www.youtube.com/user/DevartSoftware/
#SQLUnitTest #DevOpsAutomation #DevOpsTools #SQLTools #SQLDatabaseAutomation #dbForge #Devart
Closed Caption:
Want to boost database development with the DevOps practices?
This video series will cover how to set up each and every step of the DevOps workflow
and how the dbForge product can help with it.
The process can be visualized like this:
In this part of the video, we’ll look into
how specifically dbForge Unit Test takes part
in the development process.
Execution of unit tests is one of the most important stages in the database DevOps process
because it guarantees that all changes committed by developers to the database project will
be verified and that all functionality will
continue working properly after the database
is deployed.
Before including unit tests to the DevOps testing process, they first need to be created.
You can do it with the help of dbForge Unit Test.
This tool also enables you to execute these tests during the CI process.
Including dbForge Unit Test into the DevOps process
The following conditions are necessary for unit test execution:
the tSQLt framework is installed in the database you need to test;
unit tests are present in this database;
You can install the tSQLt framework with the help of the dbForge Unit Test tool for the
database on which unit tests will be executed.
dbForge Unit Test provides a convenient interface for creating new tests and modifying existing
ones.
A set of unit test creation scripts will be
represented by several *.sql files.
To deploy scripts to a database, we’ll use the Invoke-DevartExecuteScript Powershell
cmdlet.
This cmdlet invokes the unit test tool and executes tests on the specified database.
As we can see, unit testing is one of the
most important steps in the DevOps process.
With the help of automated tests, it allows you to quickly locate all errors on early
stages of development
and, correspondingly, minimize risks during deployment to the production environment.
Just download dbForge DevOps Automation solution and organize safe and stable DevOps process
in a seamless way.
Video Length: 02:28
Uploaded By: Devart
Published: 11/13/2020
View Count: 1,799