StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Deploying to Mirrored Database

Deploying to Mirrored Database

Tim Dol — Wed, 30 Jun 2010 07:22:40 GMT

I have a couple of questions regarding package deployment.

1) Is there a problem deploying packages against databases that are being mirrored? We have a customer running mirroring and they said the deployment fails. (I haven't actually seen the error yet, I'm just being proactive to find out if there are problems). Are there procedures to follow when deploying to mirrored databases?

2) What SQL permissions are required to deploy a package to a database? A few of our customers have very tight security on the databases so I need to supply them with a permissions list.

Thanks,

Tim

RE: Deploying to Mirrored Database

Ivan George Borges — Wed, 30 Jun 2010 07:22:40 GMT

[quote]1) Is there a problem deploying packages against databases that are being mirrored? We have a customer running mirroring and they said the deployment fails. (I haven't actually seen the error yet, I'm just being proactive to find out if there are problems). Are there procedures to follow when deploying to mirrored databases?[/quote]

There shouldn't be any issue. Guess the error message could help us here.

[quote]2) What SQL permissions are required to deploy a package to a database? A few of our customers have very tight security on the databases so I need to supply them with a permissions list.[/quote]

I would say that being a member of the db_owner database role would do it.