microsoft / microsoft/vscode-mssql

[Bug]: After using the "excluded from project" feature, schema compare reports a deletion of table

Open
#20,617 2 comments 0 reactions 1 assignee Assigned to @tauseefsiddique10 View on GitHub
Area - Schema Compare Bug Needs More Info User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

I expected the Schema Compare to not make comparisons on any Schemas that are excluded from the project. Instead, after using the excluded from project, Schema Compare reports that there was a deletion. I thought the exclusion would be like a "gitignore" for comparing schemas, but that's not the actual behavior.

### Steps to Reproduce

1. Create project from database
2. Use `Schema Compare` to show no difference between local project and database
3. Choose a schema to exclude and click `Exclude from project`
4. Use `Schema Compare` to show differences between local project and database

### Affected 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
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

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

_No response_

### Environment Information

SQL Database Projects v1.5.4
SQL Server (mssql) v1.36.0
SQL Server
Version: 1.106.0
OS: Windows_NT x64 10.0.26100

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.