Home Page Icon
Home Page
Table of Contents for
Survey
Close
Survey
by Carl Rabeler
Microsoft Azure Essentials Migrating SQL Server Databases to Azure
Cover
Title Page
Copyright Page
Contents
Introduction
Who should read this ebook
Assumptions
Conventions and features in this ebook
Acknowledgments
Errata, updates, & ebook support
Free ebooks from Microsoft Press
We want to hear from you
Stay in touch
Chapter 1. Overview of SQL Server in Microsoft Azure
Overview of SQL Server in Microsoft Azure
What do I need to know about Azure?
An overview of Azure services
Subscribing to Azure services
Paying for Azure services
What are the Azure deployment models?
Using the Azure portal
Getting started with Azure PowerShell
Getting started with the Azure Command-Line Interface
What is Azure storage?
What are Azure virtual machines?
What is SQL Server in an Azure virtual machine (IaaS)?
What is Azure SQL Database (PaaS)?
When to use SQL Server in a VM (IaaS) and when to use Azure SQL Database (PaaS)
Lab: Create an Azure subscription and connect to Azure portal
Create an Azure trial subscription
Connect to the Azure portal with your Azure trial subscription using your browser
Install Azure PowerShell 1.0
Connect to Azure using PowerShell
Chapter 2. Getting started with SQL Server in an Azure virtual machine
Overview of an Azure virtual machine
Selecting a deployment model
Defining a resource group within an Azure region
Defining storage resources
Defining network resources
Defining compute resources
Additional configuration options
Configuring diagnostics
Configuring an availability set
Provisioning the virtual machine with the Windows operating system and SQL Server
Configuring SQL Server in the virtual machine
Configuring SQL Server storage
Configuring authentication for SQL Server
Configuring connectivity to your Azure virtual machine
Selecting a provisioning method
Walk-through: Getting started with SQL Server in an Azure virtual machine
Provisioning a SQL Server virtual machine using the Azure portal
Viewing and configuring your virtual machine in the Azure portal
Connecting to your virtual machine
Connecting to SQL Server within the virtual machine
Connecting to SQL Server in your virtual machine from another computer
Conclusion
Chapter 3. Getting started with an Azure SQL Database
Overview of SQL Database
Service tiers
Service tiers and performance levels
Service tiers and capabilities
SQL Database logical server
Firewall rules
Server-level firewall rules
Database-level firewall rules
Walk-through: Getting started with an Azure SQL Database
Provisioning a SQL Database logical server and database using the Azure portal
Viewing and configuring your SQL Database in the portal
Connecting to your SQL Database using SQL Server Management Studio
Conclusion
Chapter 4. Migrating a database to Azure
Overview of migrating a user database to Azure
Managing breaking changes between SQL Server versions
Migrating and managing metadata stored outside a user database
Migrating a SQL Server user database to a SQL Server instance in an Azure virtual machine
Migrating using full database backup for simplicity
Migrating using full database and transaction log backups to minimize downtime
Migrating a SQL Server user database to an Azure SQL Database
Determining and resolving Azure SQL Database V12 compatibility issues
Migrating a compatible SQL Server database to SQL Database
Using transactional replication to migrate a SQL Server user database to SQL Server in an Azure virtual machine or to Azure SQL Database
Migrating a non–SQL Server user database to SQL Server in an Azure virtual machine or an Azure SQL Database
Walk-through: Migrating a SQL Server database to SQL Server in an Azure virtual machine using SQL Server backup and restore
Backing up a SQL Server 2008 R2 user database to local storage
Copying the backup file from local storage to Azure blob storage
Copying the backup file from Azure blob storage to the Azure virtual machine
Restoring the SQL Server 2008 R2 user database backup to SQL Server 2016 in an Azure virtual machine
Walk-through: Migrating a SQL Server database to SQL Database using a BACPAC file
Using the Deploy Database to Azure SQL Database Wizard to migrate a user database to SQL Database
Conclusion
Chapter 5. Authentication, authorization, and data resiliency
Securing connections
Configuring and securing connections to SQL Server in an Azure virtual machine
Configuring and securing connections to Azure SQL Database
User authentication
User authentication with SQL Server in an Azure virtual machine
User authentication with Azure SQL Database
Contained users
User authorization
User authorization with SQL Server in an Azure virtual machine
User authorization with Azure SQL Database
Database backups and restores
Database backups with SQL Server in an Azure virtual machine
Database backups with Azure SQL Database
Data archiving
Data archiving with SQL Server in an Azure virtual machine
Data archiving with Azure SQL Database
Walk-through: Configuring authentication and authorization with Azure SQL Database
Creating a login and a user
Creating a contained user
Granting server-level permissions to users
Walk-through: Creating a database copy using automated backups
Using automated backups to create a database copy
Walk-through: Restoring a database copy using automated backups
Using automated backups to restore a database to a point in time
Creating an archive
Conclusion
About the author
Visit us today
Hear about it first
Survey
Free ebooks
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Hear about it first
Next
Next Chapter
Free ebooks
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset