tortoise / aerich

A database migrations tool for TortoiseORM, ready to production.
https://github.com/tortoise/aerich
Apache License 2.0
804 stars 90 forks source link

What changes are required when running a script for production ? #256

Closed AnimeshRy closed 1 year ago

AnimeshRy commented 1 year ago

I have a migration script to update DB tables which runs fine on a staging environment. As production env contains a ton of tables and running with script would block down entire DB, I'd prefer to find a way to minimize that. Maybe running the code in batches or doing a bulk update/create.

Are there any ways present on Tortoise ORM which could help me in this direction ? If anyone has an example of a similar script, please link them below.

Thanks, Animesh