2,080 questions
0
votes
0
answers
47
views
How do I maintain DacFx/Sqlpackage versioning lock-step with old-style sqlproj?
Without VS 2026 tooling for new SDK-style sqlproj and VS 2022 tooling still being preview and incompatible with legacy SSDT, I am left with having to maintain some legacy old-sqlproj projects.
I want ...
- 8,098
1
vote
0
answers
110
views
How to fix SQLCMD variable DatabaseName not being excluded from schema compare in VS Code or Rider
When I run a schema compare in Rider in the new SDK-style .sqlproj format where the [$(DatabaseName)] value is in the *.sql code and the resolved database name is in the database side, it still ...
- 4,215
0
votes
0
answers
71
views
How to prevent SSDT/DACPAC publish with DropObjectsNotInSource=True from dropping Azure Functions az_func runtime tables
I’m deploying a SQL Server/Azure SQL database using an SSDT .sqlproj (DACPAC) and SqlPackage.exe (DacFx publish). For local dev we require DropObjectsNotInSource=True so schema drift/renames are ...
- 940
0
votes
0
answers
109
views
error MSB4226 Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found when running GitHub actions build on a selfhosted Windows Runner
I'm building a selfhosted github runner image using a docker file.
When we run a github actions build on this runner I get the following error:
MSBuild auto-detection: using msbuild version '18.0.5....
1
vote
0
answers
182
views
Using non hard-coded values for test conditions within VS SQL Server Unit Test Project
Is it possible to use non hard-coded values for asserting scalar values in VS SQL Server unit test project? Below I have the variable @ResourceId that I'd like to test against the value of a column ...
- 11
0
votes
0
answers
107
views
Random Change tracking enabled error when deploying `DACPAC` using `DacFx`
We have a SQL Server Data Tools (SSDT) Visual Studio database project, and we deploy the DACPAC output using DacFx + PowerShell scripts.
In this project, we enable:
Database-level change tracking via ...
- 33.9k
0
votes
1
answer
204
views
How do I get Visual Studio Code to restore and build SSDT related projects in a solution?
I am able to create an SSDT solution, with projects, and build in VS Pro 2022 without any issues. However, when I do the same in VS Code, I get the following warning:
Restore succeeded with 1 warning(...
- 4,097
0
votes
1
answer
86
views
Unable to open / upgrade SSDT 2015 package in Visual Studio SSDT 2022
Currently all of our SSDT packages have been created with SQL Server Data Tools 2015
We are looking to upgrade to SSDT 2022.
I installed Visual Studio 2022 with the following selected during setup:
...
- 314
0
votes
1
answer
87
views
Using SSDT, how to reference a second database via DacPac where the schema in the four part name is a parameter?
I have a scenario where my SSDT project needs to reference a second database via Dacpac, but the destination schema could change per environment. In the example below I have my primary database with a ...
- 121
-1
votes
1
answer
187
views
Visual Studio database project dacpac reference errors
We have a Visual Studio SQL server data tools solution with multiple databases for an on-premise database server. Our datawarehouse database references many of the source databases which have been ...
- 143
0
votes
0
answers
170
views
Is DTExec.exe and SSIS backwards compatible?
We have hundreds of SSIS packages created with Visual Studio 2015 and currently they all run perfectly fine through batch commands that execute the following:
C:\Program Files (x86)\Microsoft SQL ...
- 314
0
votes
0
answers
219
views
Which Visual Studio 2022 edition should I select for using SQL Server Data Tools?
To create Integration Service packages before, I could set up the development environment without caring about Visual Studio edition. Because the shell copy of Visual Studio 2017 was apparently ...
- 67
-1
votes
2
answers
2k
views
Existing SSIS package not loading correctly in newer version of Visual Studio
I am in the process of updating our local instance to SQL Server 2022. I have all of the SQL Server configuration done, but I am having problems getting our SSIS packages to open in Visual Studio and ...
- 21
0
votes
1
answer
192
views
"Schema Comparison" in VS2022 ignores "Ignore keyword casing"
I can't upload the Image to SO for some reason so see the imgur screenshot here#1 and here#2 and here#3.
[edit] In 3rd example, the only diff emphasis is on the keyword CREATE (casing problem) while ...
- 13.1k
0
votes
1
answer
57
views
SQL Server Object Explorer, set focus on table from Query
I have setup a connection to my local SQL Server, over the "SQL Server Object Explorer" in Visual Studio.
Is there a way, built in or maybe with an extension, for setting the focus to a ...
- 866