Database lifecycle management (DLM) is a policy-based approach to managing databases and data assets. DLM is not a product but a comprehensive approach to managing the database schema, data, and metadata for a database application. A thoughtful and proactive approach to DLM enables an organization to manage data resources according to appropriate levels of performance, protection, availability, and cost.
DLM begins with discussion of project design and intent, continues with database develop, test, build, deploy, maintain, monitor, and backup activities, and ends with data archive. This topic provides an overview of the stages of DLM that begin with database development and progress through build, deploy, and monitor actions (Figure 1). Also included are data management activities, and data portability operations like import/export, backup, migrate, and sync.
Use the SQL Server Database Lifecycle Management diagram to identify the applications and actions that apply to your database scenarios. To get additional information about a specific DLM task, scroll down to the links and click a topic name.
To communicate with the author of this topic with comments or suggestions, send e-mail to Louis Berner: Louisb@microsoft.com. Please mark your message with Subject: “DLM topic on MSDN.”image
This is something that every dev and app that stores data has had to deal with, updates and changes over time. This is interesting guidance and series of links. Looks a little complicated, but it's not an easy problem to solve either...