This post demonstrates how loading data from an SQL script for a particular database platform. This is ideal for development stage when you need some seed data to fill in existing database tables.
When an embedded in-memory H2 database is used with Spring Boot, your data can be accessed via H2’s web console available in your application. If you are using Spring Security, you may need to exclude the /h2-console URL from the authentication process.
Please be aware that this type of configuration is not ideal for production. I’d recommend it only for prototyping.