microsoft / microsoft/vscode-mssql

[Task]: Improve "Create Project from Database by using extractTarget as SqlProject

Open
#22,552 0 comments 0 reactions 1 assignee Claimed by @ssreerama View on GitHub
Bug Triage: Needed User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

Switch the "Create project from database" flow to use SqlPackage extract with extractTarget=SqlProject.

This will:
Generate a ready-to-use .sqlproj file (SDK-style) with the target platform, SDK reference, and all file includes already populated
Output SQL object files organized by schema/object type folder layout
Remove the folder structure and project style picker dialogs from the flow, since extractTarget=SqlProject produces the correct output for both without user input

### Steps to Reproduce

1. Connect to server
2. Right click and choose "Create project from database"
3. follow the quickpicks to create a project.

### 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
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [x] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

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

_No response_

### Environment Information

- Current available all versions

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [x] 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.