Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Using Views

By Steve Jones,

There are so many ways to undertake development inside of SQL Server. The growth of the platform has given us many options for solving problems and implementing features. However fundamentally altering schemas has continued to be problematic and challenging for many database developers.

Many applications are tightly tied to the underlying schema, and changing columns or tables is often so difficult that developers hesitate to make changes. Migration scripts help, but they must be manually created and are still daunting enough that many developers still avoid making changes that are potentially destructive. 

I was watching a session recently on another topic, but as part of the demo, there were changes being made to the schema while an application continued to insert and update rows without breaking. I've rarely seen people bother with this, but I'm wondering how many of you use this technique:

Are you using views to allow schema changes?

The demo showed the rename of a table and the creation of a view to allow an application to continue to work with minimal delays. A well designed application that retries batches wouldn't flinch at this change. Once it's complete, further schema alterations like horizontal/vertical partitioning can occur seamlessly.

I used this technique back in v6.5, but there were problems scaling views and I've been hesitant to try it since. However the performance of SQL Server has vastly improved and I'm interesting in whether or not others are using this regularly to upgrade their applications without downtime.

Total article views: 263 | Views in the last 30 days: 44
 
Related Articles
ARTICLE

Continuous Delivery

The practice of continuous software development is growing, with continuous integration, deployment,...

FORUM

Merging schema changes from server db to client db

Issues while merging schema changes

FORUM

DB Snapshots - Schema changes backed up?

DB Snapshots - Schema changes backed up?

FORUM

Schema Sandbox

Establish developer sandbox using schemas

FORUM

How to make SSIS resilient to database schema changes ...

How to make SSIS resilient to database schema changes

Tags
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones