Multi-Database & Migration

For two databases, define per-database DataSource + EntityManagerFactory + TransactionManager, keep entities and repositories in separate packages, mark one @Primary, and remember @Transactional is atomic within ONE database only.

MySQL to Oracle means swapping dialect, driver/URL, switching IDENTITY to SEQUENCE, and handling type differences like VARCHAR2, NUMBER, no native BOOLEAN, and empty-string-is-null.