SQL Server Multi Tenancy Setup
What you are describing seems exactly like PartitionDB*.  You can create your multi-tenant database design in more than one mode. Look at their configuration page.

Basically, you have a master database which populates metadata structure information between the database nodes. They support SQL Server and also a builtin replication mechanism if you like to use.

* I am a beta user, but not affiliated with this product otherwise.