Migrating Databases to SQL Azure

In this lab, you will use the AdventureWorksLT2008 database and show how to move an existing on-premises database to SQL Azure including: modifying the DDL and moving data via BCP and SQL Server Integration Services.

Overview

SQL Azure Database is based on Microsoft SQL Server, which makes it relatively easy to move existing SQL Server databases to SQL Azure. In this hands-on lab, you will learn how to move a schema and data to SQL Azure by using brute force Scripts with BCP command-line tool to copy data into and out of SQL Azure.

Objectives

In this hands-on lab, you will learn how to:

• Use SQL Azure as a cloud hosted database platform for your applications.
• You will learn how to
  • Migrate an existing database (schema & data)

Prerequisites

The following is required to complete this hands-on lab:

• SQL Server Management Studio 2008 R2 Express Edition

Exercises

This hands-on lab includes the following exercises:

1. Exercise 1: Moving an Existing Database to the Cloud

Estimated time to complete this lab: 30 minutes.