DBA Skills – Automated Deployment
Automated deployment is an essential skill for any DBA managing a production infrastructure. It is important to be able to perform automated deployment so that you can reproduce expected results from the deployment. In other words, before you actually deploy to your production environment, you should have experienced and tested the results of that deployment previously.
In a perfect world, or a company with deep pockets, automatic deployment is not so difficult to achieve. For the smaller company, automated deployment may consist of SQL change scripts and a few power shell scripts to perform the deployment.
In a worst case scenario, your process may consist of a written checklist and a series of change scripts. This works fine as long as there are not a lot of changes being made. The larger your change set grows, the less likely a manual method will be without error in execution.
The truth is you can deploy software without a trial deployment before production. The question is, “Can you deal with the consequences when things fail?” or, “What if you have a problem and have to roll back your changes?”
How do you automate your deployments? Are you using generic tools like team city, or Team Foundation Server? Are you using database specific tools such as ER Studio or ErWin? Have you rolled your own solution? Share your experience by writing below, or drop an Email to btaylor@sswug.org.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
Understanding SQL Server Full-text Indexing – (Part 2)
In this part, you will learn how to create full-text index using Transact-SQL, and how to manage and optimize full-text search catalogs and indexes.
Featured White Paper(s)
Encryption Key Management Simplified
Managing encryption keys is a fundamental step to securing encrypted data, meeting compliance requirements, and preventing da… (read more)
Featured Script
dba3_ExtendedProperty_level2type_demo
demo of ExtendedProperty level2type property use… (read more)