Object Deployment

SQLDBcontrol allows you to deploy multiple database objects (stored procedures, views and user-defined functions) to multiple databases on any number of SQL Server’s.

SQLDBcontrols deployment process is entirely automated - You simply choose the objects you want to deploy and then choose the databases you want them deployed to, eliminating the need to script and manually apply object definitions.

In addition, SQLDBcontrol also allows you to control how object permissions are applied to those deployed objects. You get three options:

1. Keep the object permissions the same as on the source database.
2. Keep the object permissions the same as they are on the destination database (this only works for objects that already exist at the destination).
3. Specifically choose the exact level of permissions you want for each database you are deploying to.

So not only can you control which objects are deployed and to which databases, but you also control how they are deployed.

Object Deployment

• Entirely automated deployment process – you just choose the objects you want to deploy and the databases you want to deploy to.
• Any number of objects can be deployed to any number or databases on any number of servers simultaneously.
• Control over deployment of object permissions, allowing you to choose precisely how you want each object to be deployed.