Automated Pipelines to deploy queries and stored-procedures to SQL Database
This solution specially reduces daily manual efforts for engineers who had to log in to the server and run queries or stored procedures to update the database. This solution consists of the following phases:
1. In this project we implemented a database project containing all the necessary data and details for managing and configuring the SQL database.
2. Then we created a pipeline job to build and publish the database project.
3. We successfully configured the database through a job, involving artifacts and making sure the database stays up-to-date.
4. Finally, Verified the end-to-end flow, resulting in up to a 50% reduction in manual efforts for developers.