The SQL CAF Solution Factory is collection of eBook, TaskList in DevOps Project and Excel, Security Policies suggestions that can help Microsoft customers and partners to deploy and manage Azure SQL in alignment to Cloud Adoption Framework (CAF).
The Azure Cloud Adoption Journey
-
eBook: SQL Adoption Aligned To Cloud Adoption Framework
Detailed guidance about what one needs to do in each of the Cloud Adoption phases for SQL Migration starting from Strategy, Plan, Ready, Adopt, Govern and Manage. We have supplied detailed step by step guidance(from our experiences) that will provide the steps necessary to go from zero to a complete SQL migration and management aligned to the Cloud Adoption Framework methodology.
This eBook contains the following documents:
01 - CAF Strategy Phase - SQL Migration
02 - CAF Plan Phase for SQL Migration
03 - CAF Ready Phase for SQL Migration
04 - CAF Adopt Phase - Scenario 1 - SQL Migration - On Prem to Azure VirtualMachine
04 - CAF Adopt Phase - Scenario 2 - SQL Migration - On Prem to AzureSQL Database
04 - CAF Adopt Phase - Scenario 3 - SQL Migration - On Prem to Azure Managed Instance
05 - CAF Governance Phase for SQL Migration
05.1 - CAF Governance Phase for SQL Migration - Security policies -
SQL CAF DevOps Project TaskList
When you go through the SQL migration, its a project with many different activities. We have supplied Azure DevOps Project that will provide the steps necessary to go from zero to a complete SQL migration and management.
Steps to import the DevOps Project:
- Sign in to the Azure DevOps Demo Generator site
- Provide project name, select your Org, and choose the "SQL Project - Task DevOps Template.zip" template from this GitHub Repo
-
Incase if you are not leveraging Azure DevOps for project management, no worries. We have provided all the necessary steps in an excel sheet which can be leveraged as is or imported into your own project management tool of choice.
-
CAF Governance Phase for SQL Migration - Security policies
One common question that we get is what are the security considerations for SQL Migartion. So we have provided guidance about how to leverage the Azure policies to secure your environment. This can act as a good starting point for your security consideration.
Smart Program - Strategic Migration Assessment and Readiness Tool
Azure Cloud Adoption Framework
Cloud Adoption Framework for Azure Partners
Azure Migration Program Funding
Thanks to our contributors:
Microsoft Team: Manish Dhall, Abha R Panchal, Gennady Kostinsky, Puneet Jeyasingh, Farida Bharmal
Reviewers: Brian Hitney, Rajesh Setlem, and Venkata Raj Pochiraju
We have leveraged help from Microsoft Partner Fyrsoft to create the Solution Factory