StrataFrame Forum

Deploying to Mirrored Database

http://forum.strataframe.net/Topic27580.aspx

By Tim Dol - 6/29/2010

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

By Ivan George Borges - 6/30/2010

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?

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

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.

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