Database Lifecycle Management (DLM)

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 and restore, migrate, and sync.

How to Use this Topic

Use the SQL Server Database Lifecycle Management diagram to identify the 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.”

数据库生命周期管理

Figure 1. Database Lifecycle Management scenarios and tasks for Microsoft SQL Server and Windows Azure SQL Database.

Database Lifecycle Management Tools and Scenarios

Use the links in the following tables to view documentation and video presentations about database lifecycle management.

  • SQL Server Data Tools

  • SQL Server Management Studio

  • Windows Azure SQL Database

SQL Server Data Tools

SQL Server Data Tools (SSDT) is the final name for the software application formerly known as SQL Server Developer Tools, Code-Named “Juneau”. SSDT provides a modern database development experience for the SQL Server and SQL Azure database developer. As the supported SQL Azure development platform, SSDT will be regularly updated online to ensure that it keeps pace with the latest SQL Azure features.

The following table links to videos and documentation about database development tasks using SQL Server Data Tools.

SSDT free download

Microsoft SQL Server Data Tools (SSDT) - Includes a link to the free SSDT product download, a beginner’s guide, a list of additional resources, and a link to the SSDT community forum.

Content type: Download

Source: Microsoft

Get started with SSDT

Get Started with SQL Server Data Tools - Introductory video demonstrations by Gert Drapers, an FAQ page, and links to additional SSDT resources.

Author: Gert Drapers

Content type: Video

Source: Microsoft

Database development

Microsoft SQL Server Data Tools: Database Development from Zero to Sixty - A database development video demonstration.

Author: Gert Drapers

Content type: Video

Source: Microsoft

Development best practices

Data Development Technical Documentation - Technical documentation, videos, webcasts, and code samples for database application developers.

Author: Microsoft

Content type: Reference

Source: Microsoft

Database migration

SqlPackage.exe - Documents the SqlPackage.exe command line utility that automates database migration and portability tasks, including Extract, Export, Import, Publish, DeployReport, DriftReport, and Script.

Author: Louis Berner

Content type: MSDN topic

Source: Microsoft

Reference

Tools and Utilities Support (Windows Azure SQL Database) - Describes tools and utilities that can be used with Windows Azure SQL Database.

Author: David Schwartz

Content type: MSDN topic

Source: Microsoft

Reference

Guidelines and Limitations (Windows Azure SQL Database) - Describes differences between Widows Azure SQL Database and on-premise instances of SQL Server.

Author: David Schwartz

Content type: MSDN topic

Source: Microsoft

Community

SQL Server Data Tools Team Blog - Official team blog for SSDT on and off-premise database development.

Author: SSDT feature team

Content type: Blog

Source: Microsoft

SQL Server Management Studio

SQL Server Management Studio (SSMS) is a software application used for accessing, configuring, managing, and administering all components of SQL Server. SSMS includes both script editors and graphical tools that work with SQL Server objects and features.

The following table links to videos and documentation about database monitoring and management tasks using SQL Server Management Studio.

SSMS free download

Microsoft SQL Server 2012 Express - Microsoft SQL Server 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight web sites and desktop applications.

Author: Microsoft

Content type: Download

Source: Microsoft

Get started tutorial

Managing Windows Azure SQL Database Using SQL Server Management Studio - This tutorial describes how to use SQL Server Management Studio to manage SQL Database logical servers and databases.

Author: Louis Berner

Content type: Tutorial

Source: Microsoft

Backup and restore

Backup and Restore of SQL Server Databases - Describes the benefits of backing up SQL Server databases, covers basic backup and restore terms, introduces backup and restore strategies for SQL Server, and presents security considerations for SQL Server backup and restore.

Author: Karthika Raman

Content type: MSDN topic

Source: Microsoft

Migration to Windows Azure

Migrating Databases to Windows Azure SQL Database - This topic describes various options to migrate an existing SQL Server database to Windows Azure SQL Database.

Author: Karthika Raman

Content type: MSDN topic

Source: Microsoft

Hybrid architectures

The New World of Data: SQL Server and Hybrid IT - This video discusses solutions that span on-premise and cloud environments.

Author: Gert Drapers

Content type: Video

Source: Microsoft

Data sync

Get Started with SQL Data Sync - Describes how to use the SQL Data Sync user interface to easily create and schedule bi-directional data synchronizations between the cloud and on-premise instances of SQL Server.

Author: Russ Herman

Content type: MSDN topic

Source: Microsoft

Community

SQL Server Team Blog - The official team blog for SQL Server.

Author: SQL Server feature team

Content type: Blog

Source: Microsoft

Windows Azure SQL Database

Windows Azure SQL Database enables organizations to rapidly create, scale and extend applications into the cloud with familiar tools and is built on core SQL Server technology.

The following table links to videos and documentation about database monitoring and management tasks that use the SQL Database service.

Get the free trial

Windows Azure 90-day Free Trial - A free trial offer that provides you 90 days to deploy web sites to the cloud, run virtual machines, create scalable applications, and add a scalable, secure back-end to a mobile application.

Author: Microsoft

Content type: Download

Source: Microsoft

Tutorial

Get Started with Windows Azure SQL Database - Learn the fundamentals of Windows Azure SQL Database administration using the Windows Azure Management Portal. If you are new to database administration, you can follow these lessons to learn essential skills in about 30 minutes.

Author: Louis Berner

Content type: Tutorial

Source: Microsoft

Azure training

Windows Azure Training Kit – April 2013 - The Windows Azure Training Kit provides a comprehensive set of technical content including hands-on labs and presentations that are designed to help you learn how to use the latest Windows Azure features and services.

Author: Scott Klein

Content type: Training

Source: Microsoft

Azure training

Windows Azure Training Kit - GitHub - This Windows Azure Training Kit includes hands-on labs, presentations, and samples to help you build applications that use Windows Azure.

Author: Community

Content type: Training

Source: Open source

Windows Azure worker roles

Currently, SQL Azure does not support SQL Server Agent. However, you can use the information in the following blogs to configure a Windows Azure worker role and some custom code to perform many SQL Server Agent-like tasks.

Author: Wayne Walter Berry

Content type: Blog

Source: Microsoft

Performance monitoring

Sys.dm_db_wait_stats - Returns information about all the waits encountered by threads that executed during operation. You can use this aggregated view to diagnose performance issues with Windows Azure SQL Database and also with specific queries and batches.

Author: Louis Berner

Content type: MSDN topic

Source: Microsoft

Monitoring

Monitor Windows Azure SQL Database Using Dynamic Management Views - Provides information on how to use dynamic management views to detect common performance problems caused by blocked or long-running queries, resource bottlenecks, or poor query plans.

Author: Louis Berner

Content type: MSDN topic

Source: Microsoft

Backup and restore

Windows Azure SQL Database Backup and Restore - Backing up and restoring data is different in Windows Azure SQL Database than for an on-premise SQL Server. This topic describes the recommended strategy to backup and restore a Windows Azure SQL database.

Author: Karthika Raman

Content type: MSDN topic

Source: Microsoft

Import and export

How to Import and Export a Windows Azure SQL Database – Describes how to create a logical backup (BACPAC) file that contains the schema definition and a table data for a Windows Azure SQL database.

Author: Karthika Raman

Content type: MSDN topic

Source: Microsoft

Database portability

How to: Import and Export a Database (Windows Azure SQL Database) - Describes how to use Windows Azure SQL Database Import and Export operations to copy databases between Windows Azure SQL Database servers, or to migrate databases between on-premise instances of SQL Server and Windows Azure SQL Database.

Author: Karthika Raman

Content type: MSDN topic

Source: Microsoft

Connection management

Windows Azure SQL Database Connection Management - This topic provides an overview of SQL Database and its network topology, and then describes reasons for connection losses and provides guidelines and best coding practices to manage the connection life cycle in SQL Database.

Author: Selcin Turkarslan

Content type: Technet wiki

Source: Community

Troubleshooting connections

Windows Azure SQL Database Connectivity Troubleshooting Guide - This topic documents common connectivity error messages that you might see while connecting to Windows Azure SQL Database.

Author: Selcin Turkarslan

Content type: Technet wiki

Source: Community

Windows Azure Technical Support blogs

The following blogs are published by Microsoft Customer Support Services to provide solutions to common customer issues:

Authors: Narahari Dogiparthi, Ki Yi

Content type: Blog

Source: Microsoft

Community

Windows Azure SQL Database Community Forum - Discuss database technologies like SQL Database, Reporting, and the Data Synchronization Service.

Author: Community

Content type: Forum

Source: Open source

Community

Windows Azure Team Blog - The official team blog for Windows Azure.

Author: Windows Azure feature teams

Content type: Blog

Source: Microsoft

Manageability, monitoring

Windows Azure Service Dashboard - This Windows Azure web site shows the health status of the Windows Azure Platform running at data centers around the world. You can subscribe to RSS feeds for individual data centers, or view detailed incident reports for a service that is not running as expected.

Author: Azure Ops

Content type: Reference

Source: Microsoft

Community

Stackoverflow for Windows Azure SQL Database - View questions and answers from other Windows Azure SQL Database users, or post questions and answers about SQL Database performance, troubleshooting, or implementation details.

Author: Community

Content type: Forum

Source: Open source

请参阅

其他资源

Windows Azure Home Page

Windows Azure Developer Center

Windows Azure Manage Center

Windows Azure Team Blog

Windows Azure Support Options