Back

Application Modernization - Azure SQL Migration Demo (Video)

Explore Cloud App Security with Agile IT's demo video, showcasing how to safeguard your data in Office 365 and beyond, ensuring comprehensive cloud security.

5 min read
Published on Aug 31, 2018
azure_sql_migration_demo_video

Tech Talks are a weekly opportunity to learn how to do more, and do it securely with your cloud software and services. Each week, we host a short talk from a subject matter expert, followed by a community driven Q&A where Agile IT’s clients can ask our engineers any of their most pressing questions. This is a free service for our clients. August 30th’s Tech Talk featured Rich Carlsen, Microsoft Cloud Solutions Architect who provided a easy to follow Azure SQL Migration demo. In this demo you learn how to migrate and existing SQL database to an Azure Virtual Machine.

Application Modernization Strategies on Azure

Rich began by showing how Application Modernization fits into the overall cloud journey of an enterprise, from generating a roadmap to full modernization, taking advantage of all the benefits cloud computing can offer.

A Real World Cloud Journey

Cloud Roadmap

To begin, it is important to have a roadmap. Identify what will actually add business value and focus on projects that are easy targets for moving to the cloud, then the cloud enablers, which are already built in the cloud, or are incredibly easy to migrate.

  • Business Value
  • Low Hanging Fruit
  • Cloud Enablers

Migrate and Lift n’ Shift

Next, look at what can be moved to the cloud without completely rebuilding. Virtual servers allow you to run many legacy line of business apps in a virtual server instead of a costly local machine, databases can be moved easily to AzureSQL. Backups and business continuity is probably the most obvious of these shifts, as data recovery gains exponentially more utility in the cloud.

  • Line of Business Apps
  • Databases
  • Websites
  • Integrations and Middleware
  • Business Continuity (Data Recovery)

Cloud Optimization

It is debatable whether optimization or modernization is the true next step in the cloud journey, and it largely depends on your business. In optimization, you begin to make the updates and changes that allow you to take full advantage of the benefits of the cloud. Domain controllers, active directory, file servers, and site backups are all capable of greater functionality and ease of use in the cloud, but it does require changing the way some of your systems operate.

  • Azure SQL Database
  • Azure Files
  • Azure AD Domain Services
  • Azure Active Directory
  • Azure Site Recovery and Backup

Modernize

In cloud modernization, you begin to take full advantage of the cloud. Here you gain capabilities that would be prohibitive or even impossible with standard infrastructure. Business intelligence and artificial intelligence are two great examples of functions that are incredibly difficult to implement with a traditional on-premises infrastructure.

  • Azure Function Apps
  • Azure Web Apps
  • Container Services
  • Azure API Apps
  • Office 365
  • Dynamics
  • Artificial Intelligence
  • Power BI

Azure Migration Tools

(These are available in your Azure Portal)

  • Azure Migrate - Easily Discover, Assess, right-size, and migrate your on-premises VMs to Azure
  • Azure Database Migration Service - Simplify on-premises
  • Cost Management - Optimize what you spend on the cloud, while maximizing cloud potential
  • Site Recovery - Orchestrate protection and recovery of private clouds
  • Data Box - Secure, rugged appliances for Azure data transfer

Azure Database Migration Tools

Microsoft Data Migration Assistant 4.0 Azure Database Migration Service

The Demo

Azure SQL Migration Demo(Click here to jump right to the demo) For the demo, Rich had already provisioned all of the needed virtual machines, including a VM running SQL that would be migrated to Azure, then from there it would be further migrated to an Azure SQL instance. Using open source health data to populate the database.

On the source VM, he demonstrated how to select his data sources, and showed the results of a the SQL Server feature parity assessment that showed that there were no databases affected by unsupported features or partially supported services, the assessment checked 140 comparability DB issues and came up clean. Moving on to the migration, he selected the  two tables he planned on migrating. The migration itself was as simple clicking a button to generate a schema creation script then clicking the button to “Deploy schema”.

Moving back to the Azure Portal, he showed that the schema was in place.  He moved into the Azure Database Migration Project where he showed the migration wizard, which simply asked for the Source SQL Server instance name, the authentication method and for the DB user credentials. Migration target details had the same questions.

Once the source and target are selected, Rich mapped the target database, which consisted of verifying the name, and selecting the desired tables. After selecting the validation options, he simply clicked migrate and it was done in a few seconds.

Bonus Materials

Ever generous, Rich shared a number of cool resources:

Plus 3 free Azure related eBooks:

 

Still on SQL 2008?

The July 9th, 2019 end of support for SQL Server 2008 and SQL Server 2008 R2 is upon us! This end of free security updates is going to leave your databases vulnerable. Even if you aren’t ready to update, Microsoft is offering an additional 3 years of Extended Support on SQL 2008 databases that shift to hosting on Azure Virtual Machines. Additionally, by working with Agile IT, you can save up to 55% if you use your existing licenses to migrate to Azure SQL with Azure Hybrid Benefit. Request a quote to find out how our managed DevOps services can make this a seamless migration.

This post has matured and its content may no longer be relevant beyond historical reference. To see the most current information on a given topic, click on the associated category or tag.

Related Posts

Risks of not using a CMMC RPO

The Risks of Not Using a CMMC RPO for Compliance and Certification Readiness

A CMMC RPO helps organizations prepare for certification and avoid compliance failures. Learn why working with an RPO is essential for achieving CMMC compliance.

Mar 20, 2025
8 min read
CMMC 2.0 Require GCC High for Compliance

Does CMMC 2.0 Require GCC High for Compliance?

Does CMMC 2.0 require GCC High? Learn the cloud options for compliance, data security, and protecting CUI under NIST 800-171 and DFARS.

Mar 17, 2025
10 min read
Office 365 License Comparison: Business Plans Vs. E5, E3 and E1

CMMC RPO vs a C3PAO: Understanding Their Roles in Compliance

Understanding the difference between an RPO and a C3PAO is crucial for CMMC compliance. Learn why they should be separate and how an RPO helps prepare for certification.

Mar 15, 2025
6 min read
Can You Meet CMMC with Google Workspace?

Can You Meet CMMC with Google Workspace?

Is Google Workspace CMMC compliant? Learn about its DFARS, NIST 800-171, and ITAR limitations and how migrating to GCC High ensures full compliance.

Mar 4, 2025
7 min read
Is Maintaining a GCC High Tenant Worth It for Non-Government

Evaluating the Need for a GCC High Tenant in Non-Government Organizations

Explore whether maintaining a GCC High tenant is necessary for organizations not involved in government work. Understand the pros and cons, costs, and compliance considerations.

Feb 25, 2025
7 min read
Top 10 Reasons to Partner with an MSP for Security and Compliance

Top 10 Reasons to Partner with an MSP for Security and Compliance

Discover why partnering with an MSP for security and compliance is critical for organizations navigating FAR CUI and CMMC requirements.

Feb 21, 2025
8 min read

Ready to Secure and Defend Your Data
So Your Business Can Thrive?

Fill out the form to see how we can protect your data and help your business grow.

Loading...
Secure. Defend. Thrive.

Let's start a conversation

Discover more about Agile IT's range of services by reaching out.

Don't want to wait for us to get back to you?

Schedule a Free Consultation

Location

Agile IT Headquarters
4660 La Jolla Village Drive #100
San Diego, CA 92122

Secure. Defend. Thrive.

Don't want to wait for us to get back to you?

Discover more about Agile IT's range of services by reaching out

Schedule a Free Consultation