Skip to content

Shows how to perform CI/CD for SQL database in Fabric

License

Notifications You must be signed in to change notification settings

chantifiedlens/ADO-SQLDatabaseinFabric

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ADO-SQLDatabaseinFabric to perform CI/CD for SQL database in Fabric

Contains a template that you shows two ways to perform CI/CD for SQL database in Fabric. Based on a blog post that covers 'two ways to perform CI/CD for SQL databases in Fabric using YAML Pipelines'.

A brief is below.

Both methods use a YAML pipeline, which you can find in the AzureDevOpsTemplates folder.

In order to use them in Azure Pipelines you can either import or fork this repository into another GitHub repository or into Azure Repos.

Afterwards, you can select the YAML file in Azure Pipelines and tailor the pipeline to suit your needs.

Method one

First method is by creating a dacpac file based on a SQL database project to a SQL database in Fabric.

Which is the database project you see in this repository.

You can find the template for the YAML pipeline in the 'AzureDevOpsTemplates/SQLDBinFabricDatabaseProject.yml'.

Method two

Second method is by extracting the schema of an existing SQL database in Fabric into a dacpac file. Which you then deploy to another SQL database in Fabric.

You can find the template for the YAML pipeline in the 'AzureDevOpsTemplates/SQLDBinFabricExtractSchematoDacpac.yml'.

This repository is provided "as is" based on the MIT license. Basically, I am not responsible for your use of it.

About

Shows how to perform CI/CD for SQL database in Fabric

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages