Description
Hello,
I'm trying to restructure a process deployment of an existing AZURE SQL Database.
I've created an new SQL project (in VS Code and in VS 2022 Pro) and used the "import form existing database" feature to import SQL objects to my newly created project.
However, the import is missing some SQL Objects.
In my case a full schema with all his tables, views,etc... is missing.
Moreover the project build returns an error saying there is missing objects references, pointing to the not imported schema objects !
For example, for this error :
View: [Expo].[VW_GetAccounts] has an unresolved reference to object [CDC].[AccountsEvents].
I can see the object [CDC].[AccountsEvents] in the database via SSMS, but i do not see it in the project (neither VSC nor VS2022).
Have anyone faced this same issue ?
Many Thanks for the help.
Steps to Reproduce
In vs code:
- Create new Database Project
- Click on "Update Project from Database"
- Chose the source database connection profile
- Select "Apply all changes"
- Wait for the import to finish
Affected Area
If you selected "Other", please describe the affected area
No response
Environment Information
- VS code Version: 1.119.0 (user setup)
- Commit: 8b640eef5a6c6089c029249d48efa5c99adf7d51
- Electron: 39.8.8
- ElectronBuildId: 13870025
- Chromium: 142.0.7444.265
- Node.js: 22.22.1
- V8: 14.2.231.22-electron.0
- OS: Windows_NT x64 10.0.17763
- MSSQL Extension Version : 1.42.2
- Operating System : WINDOWS SERVER 2022
- Connextion Type : AZURE SQL DATABASE
Confirmation
Description
Hello,
I'm trying to restructure a process deployment of an existing AZURE SQL Database.
I've created an new SQL project (in VS Code and in VS 2022 Pro) and used the "import form existing database" feature to import SQL objects to my newly created project.
However, the import is missing some SQL Objects.
In my case a full schema with all his tables, views,etc... is missing.
Moreover the project build returns an error saying there is missing objects references, pointing to the not imported schema objects !
For example, for this error :
View: [Expo].[VW_GetAccounts] has an unresolved reference to object [CDC].[AccountsEvents].
I can see the object [CDC].[AccountsEvents] in the database via SSMS, but i do not see it in the project (neither VSC nor VS2022).
Have anyone faced this same issue ?
Many Thanks for the help.
Steps to Reproduce
In vs code:
Affected Area
If you selected "Other", please describe the affected area
No response
Environment Information
Confirmation