I used SQL Server 2014 Management Studio to connect to the database server using SQL Server Authentication. SQL Server Configurationįor this post, I’m using SQL Server 2014 Express installed locally on my laptop. In this post, I will discuss Spring Boot configuration for Microsoft SQL Server.
One of my previous post on Integrating Spring Boot for MongoDB covers that. The level of decoupling even allows you to easily switch between an RDBMS and a NoSQL database, such as MongoDB.
Which allows you to run your code against multiple databases. When you’re using Spring Data JPA with an ORM technology such as Hibernate, the persistence layer is nicely well decoupled. Spring makes switching between RDBM’s simple.
I have written a series of posts on integrating Spring Boot for Oracle, MySQL, MariaDB, and PostgreSQL. While in-memory databases are great to develop against, data is not persisted to disk, thus is lost when the database is shut down.Īs the development progresses, you would most probably require an RDBMS to develop and test your application before deploying it to use a production database server. In-memory databases come with several restrictions making them useful only in the development stages in local environments. Spring programmers typically prefer writing code against such lightweight in-memory database, rather than on an enterprise database server such as Microsoft SQL Server or Oracle. Out of the box, Spring Boot is very easy to use with the H2 Database.