Open Closed

Database Per Tenant Migration for 1000+ Databases #1210


User avatar
0
falsharif created
  • ABP Framework version: v4.2.2
  • UI type: / Blazor
  • DB provider: EF Core /
  • Tiered (MVC) or Identity Server Separated (Angular): no

Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ? its currently taking hours to finish as it loops through all the tenants one by one, i understand that. But this strategy is causing us to have downtimes when we do schema updates.

Is there a way to keep the system running while migration is running ? is there a faster way to migrate this many databases ? can i migrate them back to a single database ?


4 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ?

    You can try to execute the migration concurrently, such as creating multiple threads to execute the migration separately.

    Is there a way to keep the system running while migration is running ?

    This is similar to system running when changing the database, which may be difficult or impossible.

    can i migrate them back to a single database ?

    You can back to use the Host database by deleting the tenant's connection string.

  • User Avatar
    0
    falsharif created

    hi

    Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ?

    You can try to execute the migration concurrently, such as creating multiple threads to execute the migration separately.

    Is there a way to keep the system running while migration is running ?

    This is similar to system running when changing the database, which may be difficult or impossible.

    can i migrate them back to a single database ?

    You can back to use the Host database by deleting the tenant's connection string.

    "You can back to use the Host database by deleting the tenant's connection string."

    does the script move the data back to the host database ?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    does the script move the data back to the host database ?

    No, You should do this manually.

  • User Avatar
    0
    ServiceBot created
    Support Team Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Made with ❤️ on ABP v8.2.0-preview Updated on March 25, 2024, 15:11