Microsoft Azure Essentials Migrating SQL Server Databases to Azure

Microsoft Azure Essentials Migrating SQL Server Databases to Azure

by Carl Rabeler
Released June 2016
Publisher(s): Microsoft Press
ISBN: 9781509302925

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Part of the “Microsoft Azure Essentials” series, this ebook helps SQL Server database users understand Microsoft’s offering for SQL Server in Azure. Learn how SQL Server in Azure is similar to SQL Server in an on-premises environment, and how they are different. The author, a content lead for Azure.com, walks you through the steps of getting started with SQL Server in an Azure virtual machine and with Azure SQL Database. Follow the numerous screenshots to create a trial subscription, create SQL Server in an Azure virtual machine, create an Azure SQL Database, migrate an on-premises database to each Azure environment, create users, back up and restore data, and archive data.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Contents
  5. Introduction
    1. Who should read this ebook
      1. Assumptions
    2. Conventions and features in this ebook
    3. Acknowledgments
    4. Errata, updates, & ebook support
    5. Free ebooks from Microsoft Press
    6. We want to hear from you
    7. Stay in touch
  6. Chapter 1. Overview of SQL Server in Microsoft Azure
    1. Overview of SQL Server in Microsoft Azure
    2. What do I need to know about Azure?
      1. An overview of Azure services
      2. Subscribing to Azure services
      3. Paying for Azure services
      4. What are the Azure deployment models?
      5. Using the Azure portal
      6. Getting started with Azure PowerShell
      7. Getting started with the Azure Command-Line Interface
      8. What is Azure storage?
      9. What are Azure virtual machines?
    3. What is SQL Server in an Azure virtual machine (IaaS)?
    4. What is Azure SQL Database (PaaS)?
    5. When to use SQL Server in a VM (IaaS) and when to use Azure SQL Database (PaaS)
    6. Lab: Create an Azure subscription and connect to Azure portal
      1. Create an Azure trial subscription
      2. Connect to the Azure portal with your Azure trial subscription using your browser
      3. Install Azure PowerShell 1.0
      4. Connect to Azure using PowerShell
  7. Chapter 2. Getting started with SQL Server in an Azure virtual machine
    1. Overview of an Azure virtual machine
    2. Selecting a deployment model
    3. Defining a resource group within an Azure region
    4. Defining storage resources
    5. Defining network resources
    6. Defining compute resources
    7. Additional configuration options
      1. Configuring diagnostics
      2. Configuring an availability set
    8. Provisioning the virtual machine with the Windows operating system and SQL Server
    9. Configuring SQL Server in the virtual machine
      1. Configuring SQL Server storage
      2. Configuring authentication for SQL Server
    10. Configuring connectivity to your Azure virtual machine
    11. Selecting a provisioning method
    12. Walk-through: Getting started with SQL Server in an Azure virtual machine
      1. Provisioning a SQL Server virtual machine using the Azure portal
      2. Viewing and configuring your virtual machine in the Azure portal
      3. Connecting to your virtual machine
      4. Connecting to SQL Server within the virtual machine
      5. Connecting to SQL Server in your virtual machine from another computer
    13. Conclusion
  8. Chapter 3. Getting started with an Azure SQL Database
    1. Overview of SQL Database
    2. Service tiers
      1. Service tiers and performance levels
      2. Service tiers and capabilities
    3. SQL Database logical server
    4. Firewall rules
      1. Server-level firewall rules
      2. Database-level firewall rules
    5. Walk-through: Getting started with an Azure SQL Database
      1. Provisioning a SQL Database logical server and database using the Azure portal
      2. Viewing and configuring your SQL Database in the portal
      3. Connecting to your SQL Database using SQL Server Management Studio
    6. Conclusion
  9. Chapter 4. Migrating a database to Azure
    1. Overview of migrating a user database to Azure
    2. Managing breaking changes between SQL Server versions
    3. Migrating and managing metadata stored outside a user database
    4. Migrating a SQL Server user database to a SQL Server instance in an Azure virtual machine
      1. Migrating using full database backup for simplicity
      2. Migrating using full database and transaction log backups to minimize downtime
    5. Migrating a SQL Server user database to an Azure SQL Database
      1. Determining and resolving Azure SQL Database V12 compatibility issues
      2. Migrating a compatible SQL Server database to SQL Database
    6. Using transactional replication to migrate a SQL Server user database to SQL Server in an Azure virtual machine or to Azure SQL Database
    7. Migrating a non–SQL Server user database to SQL Server in an Azure virtual machine or an Azure SQL Database
    8. Walk-through: Migrating a SQL Server database to SQL Server in an Azure virtual machine using SQL Server backup and restore
      1. Backing up a SQL Server 2008 R2 user database to local storage
      2. Copying the backup file from local storage to Azure blob storage
      3. Copying the backup file from Azure blob storage to the Azure virtual machine
      4. Restoring the SQL Server 2008 R2 user database backup to SQL Server 2016 in an Azure virtual machine
    9. Walk-through: Migrating a SQL Server database to SQL Database using a BACPAC file
      1. Using the Deploy Database to Azure SQL Database Wizard to migrate a user database to SQL Database
    10. Conclusion
  10. Chapter 5. Authentication, authorization, and data resiliency
    1. Securing connections
      1. Configuring and securing connections to SQL Server in an Azure virtual machine
      2. Configuring and securing connections to Azure SQL Database
    2. User authentication
      1. User authentication with SQL Server in an Azure virtual machine
      2. User authentication with Azure SQL Database
      3. Contained users
    3. User authorization
      1. User authorization with SQL Server in an Azure virtual machine
      2. User authorization with Azure SQL Database
    4. Database backups and restores
      1. Database backups with SQL Server in an Azure virtual machine
      2. Database backups with Azure SQL Database
    5. Data archiving
      1. Data archiving with SQL Server in an Azure virtual machine
      2. Data archiving with Azure SQL Database
    6. Walk-through: Configuring authentication and authorization with Azure SQL Database
      1. Creating a login and a user
      2. Creating a contained user
      3. Granting server-level permissions to users
    7. Walk-through: Creating a database copy using automated backups
      1. Using automated backups to create a database copy
    8. Walk-through: Restoring a database copy using automated backups
      1. Using automated backups to restore a database to a point in time
      2. Creating an archive
    9. Conclusion
  11. About the author
  12. Visit us today
  13. Hear about it first
  14. Survey
  15. Free ebooks
  16. Code Snippets

Product information

  • Title: Microsoft Azure Essentials Migrating SQL Server Databases to Azure
  • Author(s): Carl Rabeler
  • Release date: June 2016
  • Publisher(s): Microsoft Press
  • ISBN: 9781509302925