SQL Server

Migrate Databases to Azure you own this product

This project is part of the liveProject series Migrate SQL Server to Azure
prerequisites
use the Azure portal, Azure Data Studio, and SSMS • configure a VPN or ExpressRoute to ensure Azure can communicate with your on-premises database server and fileshare (required for the Database Migration Service)
skills learned
set up the database migration service to enable a smooth migration of your databases from on-premises to the cloud • perform an online migration of your on-premises database to ensure minimal downtime and no data loss • verify your migration using Azure Data Studio and SSMS
Josephine Bush & Gilda Alvarez
1 week · 6-8 hours per week · INTERMEDIATE

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more


Look inside

As a database administrator for Magic Wand Services Corporation, your task is to migrate an on-premises SQL Server database to an Azure SQL Managed Instance, a task mandated by the company’s CTO in an effort to save money on resources.

You’ll use the Azure portal and Azure Data Studio to configure your database migration service for a smooth migration with no data loss and minimal downtime, then you'll perform the migration. Using the Azure portal, Azure Data Studio, and SQL Server Management Studio, you’ll verify that your database settings were implemented—and that your migration was successful.

This project is designed for learning purposes and is not a complete, production-ready application or solution.

book resources

When you start your liveProject, you get full access to the following books for 90 days.

project authors

Josephine Bush

Josephine Bush is a Microsoft Data Platform MVP. She has over ten years of broad-based experience as a database administrator in the financial, business, and energy data sectors using SQL Server, MySQL, Oracle, and PostgreSQL along with Azure and AWS. She holds a BS in information technology, an MBA in IT management, and an MS in data analytics. She presents at SQL conferences and user groups around the world, and she’s the leader of the Boulder SQL user group. She is the author of Practical Database Auditing published by Apress. You can read her blog posts on sqlkitty.com and contact her on Twitter @hellosqlkitty.

Gilda Alvarez

Gilda Alvarez graduated from the University of Central Florida with management information system (MIS) and computer science (CS) degrees. She’s currently a senior manager at Skytouch Technology and has over a decade of experience in enterprise information technology for several Fortune 500 companies. She’s worked on multi-million dollar projects for IBM, Disney, the IRS, the U.S. Federal Defense Agency, Marriott, Deloitte, and others. She has specialized in database design, implementation, and optimization, emphasizing high availability, business continuity, and migrations. She’s passionate about promoting technical and leadership education in her community. In addition to leading the information technology committee of ALPFA (Association of Latino Professionals for America in Orlando), she’s a chapter leader for PASS (Professional Association for SQL Server). These associations have empowered her to bridge the gap in IT skills in the Latino community and mentor many Latino women in technology.

prerequisites

This liveProject is for database administrators, DevOps engineers, and developers who want to migrate their on-premises SQL Server databases to Azure. To begin this liveProject, you’ll need to be familiar with the following:

TOOLS
  • SQL Server Management Studio
  • The Azure portal with full access to create services
  • Azure Data Studio
  • On-premises SQL Server installation
  • SQL Server Management Studio
  • Azure SQL Managed Instance already set up and configured for use
  • VPN or ExpressRoute
TECHNIQUES
  • Navigate and use SQL Server Management Studio
  • Navigate and use Azure Data Studio
  • Use the Azure portal

you will learn

In this liveProject, you’ll learn to migrate your on-premises SQL Server database into Azure SQL Managed Instance for optimal performance.

  • Use the Azure portal and Azure Data Studio to configure your database migration service to enable smooth migration of your databases from on-premises to the cloud
  • Perform the online migration of your databases to the cloud using Azure Data Studio
  • Verify migration success using Azure Data Studio and SQL Server Management Studio

Information About Costs

Note that Azure Managed Instance incurs costs of approximately $1/hr depending on your subscription and region.

features

Self-paced
You choose the schedule and decide how much time to invest as you build your project.
Project roadmap
Each project is divided into several achievable steps.
Get Help
While within the liveProject platform, get help from other participants and our expert mentors.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.
book resources
Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.

choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Migrate Databases to Azure project for free