MIGRATING SQL SERVER DATABASES TO AZURE
I CONTENTS 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 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 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