Hello. I have an application in production that was my first live fire use of hibernate. I did not read enough about id generators at the time and used INCREMENT. Now I need to enable a secondary process to modify these tables and so need to move away from INCREMENT.

What is a good strategy for changing the id generator on an existing database and it's data?

I forgot to mention that I am using Postgres for development and MySQL in production.

Since I am already using INCREMENT would switching to HILO and making the lower boundary above my current max id be viable? Are the any major gotchas with this?