SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Staging Deployments

By Steve Jones,

This editorial was originally published on Nov 30, 2011. It is being republished as Steve is out of the office.

Software development can be a complicated dance. Most of us do not work for a software vendor and don't have the strict requirements for our deployments when we control the client systems. That doesn't mean it's easier for us, especially as our environments grow more complex and the availability of our systems becomes more important. Application changes can become disconnected from the database changes, especially when the scope or scale of the change is large, which can present problems.

Making database changes can be challenging since we must ensure that our data is not lost as objects are altered. We have to ensure that any application functions that depend on a certain schema receive the data they need, without unnecessary errors. The timing of changes becomes more important in the database than in applications in many situations. This Friday I am curious how many of you decide to stage these changes in your environment. If you have dependent changes, I'm wondering if you might alter the database first and change the application in a later deployment.

How many of you deploy database changes before code changes?

By "before" I mean you deploy the database changes, possibly making some application changes, but there are other code changes deferred for a separate deployment at a later time. The use of views, defaults, optional parameters and more allow database changes to proceed without accompanying application changes. It may require a bit more work, but the database can potentially be changed during a less busy time, even if development or testing for the all the application changes is not complete.

The future will require more availability and stability from our systems as they become more essential to our organizations. Learning to update software, and databases, with minimal disruption is a skill that will set you apart in the future.

 
Total article views: 210 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

SSIS: Case sensitivity may expose issues with change deployment

Because SSIS is case sensitive, random VS_NEEDSNEWMETADATA errors on case-insensitive databases may ...

BLOG

Making VSTS Deployment Changes to Databases without Breaking Your Application

One of the things that I do a lot is demo changes to databases with CI/CD in a DevOps fashion....

FORUM

Database objects deployment

Database objects deployment

ARTICLE

Monitoring After Deployment

This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do yo...

ARTICLE

No Downtime Deployments

Can you deploy your database changes without any downtime? Steve Jones has a few notes.

Tags
editorial    
friday poll    
 
Contribute