# CAF_SQL_SolutionFactory

**Repository Path**: mirrors_Azure/CAF_SQL_SolutionFactory

## Basic Information

- **Project Name**: CAF_SQL_SolutionFactory
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-19
- **Last Updated**: 2026-03-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQL Solution Factory Aligned to Cloud Adoption Framework # 
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
 ![CAF](https://github.com/faridabharmal/WVD_CAF_SolutionFactory/blob/master/TechnicalEnablement/CAF.png)

## SQL CAF Solution Factory Contents

* [eBook: SQL Adoption Aligned To Cloud Adoption Framework](https://github.com/faridabharmal/SQL_CAF_SolutionFactory/tree/master/TechnicalEnablement)

   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](https://github.com/faridabharmal/SQL_CAF_SolutionFactory/tree/master/TechnicalEnablement)

    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](https://docs.microsoft.com/en-us/)  
    * Provide project name, select your Org, and choose the "SQL Project - Task DevOps Template.zip" template from this GitHub Repo 

*  [SQL CAF Project TaskList.xlsx](https://github.com/faridabharmal/SQL_CAF_SolutionFactory/tree/master/TechnicalEnablement)

   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](https://github.com/faridabharmal/SQL_CAF_SolutionFactory/tree/master/TechnicalEnablement)

   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. 


## Additional Links
 [SQL Server migration](https://azure.microsoft.com/en-us/migration/sql-server)

 [Savings with SQL on Azure](https://azure.microsoft.com/en-us/overview/azure-vs-aws/) 

 [Smart Program - Strategic Migration Assessment and Readiness Tool](https://docs.microsoft.com/en-us/assessments/?mode=pre-assessment&session=local) 

 [Data Access Migration Toolkit](https://marketplace.visualstudio.com/items?itemName=ms-databasemigration.data-access-migration-toolkit) 

 [Azure Cloud Adoption Framework](https://www.microsoft.com/azure/partners/b/enable/cloud-adoption-framework)

 [Cloud Adoption Framework for Azure Partners](https://www.microsoft.com/azure/partners/adopt?filters=all)


## Migration Funding Programs
 [Azure Migration Program Funding](https://azure.microsoft.com/en-us/migration/migration-program) 

 [Microsoft FastTrack for Azure](https://azure.microsoft.com/en-us/programs/azure-fasttrack)


## Key Contributors
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](https://www.fyrsoft.com/) to create the Solution Factory