microsoft / microsoft/vscode-mssql

[Feature Request]: SQL Database Projects do not support targeting Microsoft Fabric SQL Analytics Endpoint

Open
#20,977 0 comments 0 reactions 0 assignees View on GitHub
Area - SQL Project Enhancement User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

The VS Code mssql extension’s SQL Database Projects functionality does not currently support projects that target Microsoft Fabric SQL Analytics Endpoint. This prevents teams from using SQL projects to build, validate, and deploy database objects as part of a standard CI/CD / DevOps process.

### Problem and Motivation

There is no supported target platform (DSP / project target) corresponding to Fabric SQL analytics endpoint.

Attempts to use existing targets (Azure SQL DB, Synapse, etc.) either:

fail validation/build due to unsupported/unknown features, or

publish with incorrect assumptions about supported objects.

This blocks deployment automation and forces manual changes in Fabric.

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [x] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [x] DACPAC/BACPAC export/import
- [x] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue does not name files or tests. Start by tracing the SQL Database Projects target-platform handling and the Schema Compare and DACPAC/BACPAC integration, comparing the existing Azure SQL DB and Synapse targets. Done means Fabric SQL Analytics Endpoint projects can build, validate, compare schemas, and deploy without incorrect target assumptions.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript, vscode
Domain
databases, devops
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.