Skip to content

A SQL project based on the WideWorldImporters database with new, additional SQL objects.

Notifications You must be signed in to change notification settings

JustinFrizzell/wide-world-importers-sql-project

Repository files navigation

Introduction

Build Status

A SQL project based on the WideWorldImporters database. I've created new SQL objects in the Challenges schema:

The project has been built into a .dacpac file for easy deployment using either SQL Server Data Tools (SSDT) or Azure Data Studio (see Installation).

CI/CD is achieved using Azure Pipelines to validate the build process. SQLFluff is used to ensure consistency across code.

Project structure:

Screenshot showing structure

Installation

WorldWideImporters

WorldWideImporters is a sample database provided by Microsoft, to install follow this guide.

SQLFluff

SQLFluff is a SQL linter and formatter, to install follow this guide.

Project deployment

This repository builds into a Data-Tier Application Package (.dacpac), which is a single file containing the full database schema. This can be used to deploy the database to various environments using SQL Server Data Tools in Visual Studio or Azure Data Studio.

To deploy, download the latest .dacpac from Releases and follow this guide. This will add the Challenges schema to the WorldWideImporters database installed above.

Screenshot showing deployment

About

A SQL project based on the WideWorldImporters database with new, additional SQL objects.

Topics

Resources

Stars

Watchers

Forks

Languages