[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

Hi Francisco

Perfect timing! That article is spot on and seems to cover every aspect. Thanks!

/gustav

________________________________________
Fra: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> på vegne af fhtapia at gmail.com <fhtapia at gmail.com>
Sendt: 16. april 2015 16:07
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

since we were on this topic recently, some of you may be interested in
reading this very interesting article on Schemas :)  (Yes, I said Schemas
and interesting in the same sentence).

https://www.simple-talk.com/sql/sql-training/schema-based-access-control-for-sql-server-databases/

On Thu, Apr 2, 2015 at 10:01 AM Gustav Brock <gustav at cactus.dk> wrote:

> Thanks Francisco, that seems to be exactly what I was wondering about.
>
> /gustav
>
> ________________________________________
> Fra: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> på vegne
> af fhtapia at gmail.com <fhtapia at gmail.com>
> Sendt: 2. april 2015 18:29
> Til: Discussion concerning MS SQL Server
> Emne: Re: [dba-SQLServer] Schemas for separation of clients?
>
> Are you referring to the dataset just for a schema?
>
> one method would be to do it via using MSSMS and scripting out both the
> schema and data:
>
> http://stackoverflow.com/questions/2254878/is-there-a-way-to-export-an-entire-sql-server-database-schema-and-data-to-te
>
> On Tue, Mar 31, 2015 at 10:23 AM Gustav Brock <gustav at cactus.dk> wrote:
>
> > Thanks Francisco, I'll mark that.
> >
> > Next question is if you can manage backup and restore of individual
> > schemas - if perhaps not easily then, at least, reliably?
> >
> > /gustav