Spring Boot CRUD Rest API with MS SQL Server

In this story, we’ll implement a sample REST API that uses Spring Boot with Microsoft SQL Server.

· Prerequisites
· Overview
∘ What is Microsoft SQL Server?
∘ SQL Server editions
· Microsoft SQL Server Setup with Docker
· Getting Started
∘ Configure Spring Data SQL Server
∘ CRUD API
· Test the application
· Conclusion
· References

Prerequisites

This is the list of all the prerequisites:

• Spring Boot 3+
• Maven 3.6.3
• Java 21
• Docker and Docker compose installed (Optional if you already have a SQL Server instance)
• SQL Server instance

Overview

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is a software product used to administer the database and retrieve information. The data is organized in tables(relations), and the tables are related. Each table has…