Schema generation [DATAJDBC-536]

[spring-projects-issues]

Using this issue as the epic to track implementing Schema Generation

Issues in epic:

• Create model for sql generation #1478
• Enhance @Column annotation to allow for specifying custom SQL type, as well as length/precision.  #1488
• Validate Model for SQL schema Generation - MySQL support for initial schema generation #1479
• Integrating with Liquibase - Generate initial schema  #1473
• Integrating with Liquibase - Generating Changesets #1480
• Reduce need for script duplication when adding support for a new database type [DATAJDBC-537] #757

Original comment in ticket

Mark Paluch opened DATAJDBC-536 and commented

We should investigate how we can generate a base-schema to be used with Spring Data JDBC. Schema generation should consider a simple approach without reflecting each database quirk. We should investigate whether we could integrate with tools like Liquibase and provide customization hooks so that applications can hook into the process and provide advanced schema definitions where needed

---

Issue Links:

• DATAJDBC-537 Reduce need for script duplication when adding support for a new database type

[airoasis]

Any updates?

[kurtn718]

It seems like we would want something similar to this Liquibase project - in terms of functionality (initial schema generation and change sets)

https://github.com/liquibase/liquibase-hibernate

except that of course it would use Spring Data JDBC annotations as the source to Liquibase.