SqlDatabase: Enable snapshot isolation

[bozho]

Hi,

Would there be interest for improving/expanding xSQLServerDatabase, xSQLServerDatabasePermission and xSQLServerDatabaseRole resources?

We currently have a need for the following functionality, which we've covered with custom resources:

• enable snapshot isolation on a DB
• ~~create roles on a DB~~ Related moved to issue #846 and #847
• ~~assign permissions to roles~~ Related moved to issue #848

Enabling/disabling snapshot isolation (and perhaps other DB properties) could be added to the xSQLServerDatabase resource.

~~xSQLServerDatabaseRole is a bit confusing, since it doesn't create/delete roles. Instead, it will create a DB user for a login and assign it an existing role. I think it would be better to have a resource for managing DB roles and a separate resource for user mapping and (maybe) role membership.~~

~~xSQLServerDatabasePermission will also add a DB user if it doesn't exist and assign permissions to it. Again, I think we would benefit here from having a separate resource for DB user management and use xSQLServerDatabasePermission to manage permissions on both users and roles.~~

I'm more than happy to start working on this, but I'd like to hear others' thoughts and ideas.

[johlju]

Could you please split this issue into at least one per resource? It will be easier to comment then. Thanks. :smile:

[bozho]

Done: issues #846, #847 and #848

[johlju]

Are we tracking the snapshot isolation on a database in this issue? Could you please change the title and issue description on this issue to reflect that?

I'm all for adding this functionality. Could you please propose a schema.mof with the changes needed for handle the isolation?

[johlju]

I updated the title and issue description is this issue so we know what we are tracking with this issue. Please correct me if I'm wrong.