Hi everyone, when upgrading hydra from version 1.x to 2.x what strategy do you use? We have a large database which takes a very long time if we apply the migration command. Is it possible to only migrate a specific table instead of all? Interested in migrating the clients table only.
c
calm-kitchen-65107
02/18/2024, 4:07 PM
I've done this by copying schema for all tables to the new database but filling only clients and migrations tables with old data, creating instance with hydra 2.x, and applying migrations on it. It was important to keep old data for clients because client_policy changed and I have some human-readable values
s
steep-sundown-37288
02/21/2024, 2:50 PM
Makes sense, it really reduces the time for the migration process, thanks for sharing.
c
calm-kitchen-65107
02/21/2024, 2:58 PM
Keep in mind to move some data for refresh_token TTL if you're using it in a production environment or if you don't have to worry about re-logins then ignore them 🙃