[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

Hi John

My thought was to use the dbo schema as a "master". Then, for each client, copy the (empty) tables to a new schema and give the client exclusive user rights to this schema.

Clearly, it would be much easier to create a copy of the database, but one Azure SQL instance allows only one database, thus a new instance would be needed for each client. It will not turn "expensive" but an instance holding, say, 20 databases will, of course, be cheaper. And you know: saved costs -> your pockets.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af John W. Colby
Sendt: 31. marts 2015 16:06
Til: Discussion concerning MS SQL Server; jwcolby at gmail.com
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

I do not understand how a schema could be used in the context of an infinite (or at least ever expanding) number of clients.