Northwind OLTP Database SSDT Project

A SQL Server Database Project that defines the schema for the Northwind transactional (OLTP) database. The project uses SQL Server Data Tools (SSDT) to keep database objects under source control and produce repeatable builds and deployments.

Database objects

The project currently contains table definitions for:

• Categories
• Customers and customer demographics
• Employees and employee territories
• Orders and order details
• Products
• Regions and territories
• Shippers
• Suppliers

Project structure

NorthwindProject/
├── Schema/
│   └── tables/                # Version-controlled table definitions
├── NorthWindBI.slnx           # Visual Studio solution
├── NorthWindOLTP.sqlproj      # SSDT database project
└── NorthWindOLTP.publish.xml  # SQL Server publish profile

Build outputs under bin/ and obj/, along with Visual Studio user settings, are excluded from source control.

Requirements

• Visual Studio with the Data storage and processing workload
• SQL Server Data Tools (SSDT)
• A compatible SQL Server instance

Build

1. Open NorthWindBI.slnx in Visual Studio.
2. Right-click the NorthWindOLTP project.
3. Select Build.
4. Confirm that the generated DACPAC appears under bin/Debug/.

Publish

1. Ensure that your SQL Server instance is available.
2. Review the server and database settings in NorthWindOLTP.publish.xml.
3. Right-click the project and select Publish.
4. Review the generated deployment script before applying it.

The included profile targets a local SQL Server instance and creates or updates the NorthWindDB database. Adjust the profile for your environment; do not commit passwords or other secrets.

Purpose

This project demonstrates database schema management, relational modeling, source control, and repeatable SQL Server deployments using SSDT.