Development environment:
- Spring
- Hibernate
- JPA
- MySQL
- SQLite
Want to achieve following:
- Fetch the data from Production DB i.e. MySQL. I am able to achieve this using JPA and Hibernate.
- Dynamically generate the SQLite schema as per need and populate the data fetched from MySQL in step 1.
Question: Is this possible to dynamically generate SQLite DB schema and populate data using JPA and Hibernate ? If yes, how to do this? If no, which ORM to use to achieve this goal.
Other information: I am using Spring tool suite, JPA and hibernate to implement persistence layer. I do not want to now go back and user standard SQL queries to dynamically create schema and populate data.
I goggled around and did not get any help for this. I also looked at the Hibernate(ORM implementation) but do not see any dedicated support for SQLite. Similar in SQLite official site.
Let me know if more detail is needed.