sorry zero-downtime deployments
I understand. First of all, does ABP Commercial have a system to support non-startup releases?
Ok, where should I contact for help?
Thank you for the suggestion. I understand that using migrationBuilder.Sql allows us to add custom SQL during migration. However, I'm looking for a way to achieve this directly through EF Core's built-in migration functionality without having to manually insert SQL statements.
Our goal is to keep our migration process as consistent and maintainable as possible within the framework provided by EF Core. If there is an alternative approach or any upcoming features that might support this requirement natively, I would appreciate any guidance or suggestions you could offer.
Thank you for reaching out.
It is possible to use ALGORITHM=INSTANT without ABP Commercial. However, when using EF Core for migrations, applying specific options like ALGORITHM=INSTANT to an ALTER TABLE command might require manually running the SQL or customizing the migration scripts to include this option.
If EF Core migrations do not support this option by default, we might need to consider executing custom scripts before or after the migration to ensure the database lock is minimized.
Our goal is to achieve zero-downtime releases by minimizing database locks. We would appreciate any further guidance or suggestions you could provide on this matter.
Best regards,
Is there a way to use ALGORITHM=INSTANT using EF Core?
https://support.abp.io/QA/Questions/5642/Bugs--Issues-v74x#answer-3a0ebb18-2391-7ca7-ed1f-70af3864c62d
This error still exists in version 8.0.0 Please help me fix it