Thanks for all your answers.
Hi,
I have multiple questions.
How many tenants can we have into the same database ? Is there a limit ? Is there any suggestion regarding performance?
Do you know if I have something special to manage tenant properly or just inserted data in the new database with tenantId that belongs to the old database will work ?
Do you think both solutions works ? I prefer the 2 solutions :)
1 - Create a shared tenant in the host database and after the tenant tables was created, and after moving data inside from each tenant database.After that I will change the tenant connection string to connect on the shared database 2 - Create a new shared database that contains only tenant tables, and after moving data inside from each tenant database. After that I will change the tenant connection string for new database
( do i need to create a new tenant or only database is ok? my plan is to start from a tenant backup and then i will move data )
I also notice that there are 2 tables (GdprInfo, GdprRequests) in the tenant database that does nt have tenantId, what are these tables for ? They are empty
Thanks