I have used this architecture at 2 companies and it is by far the best for B2B scenarios where there could be large amounts of data for a single customer. It i

I have used this architecture at 2 companies and it is by far the best for B2B scenarios where there could be large amounts of data for a single customer. It is great for data isolation, scaling data across servers, deleting customers when they leave easily. The only trick are schema migrations. Just make sure you apply migration scripts to databases in an automated way. We use a tool called DbUp. Do not try to use something like a schema compare tool for releases. I have managed more than 1500 databases and it is very simple.