Questions tagged [ssdt]
SQL Server Data Tools is a free component of the SQL Server platform and is available for all SQL Server users. It provides a modern database development experience for SQL Server versions 2005 and up as well as SQL Azure.
162
questions
0
votes
1
answer
27
views
Why is SQLPackage suddenly including every scalar function in my SSDT project for ALTER in my deployment?
I have a SQL 2019 SSDT project with a large number of scalar and table-valued functions. Suddenly yesterday, my Windows TFS (on prem) deployment project's SQLPackage scripting step is suddenly ...
0
votes
1
answer
36
views
SSDT Project Will Not Publish or Generate Preview When Source and Target Partition Function Not Matched
In a SSDT project there is a partition function defined in a file as follows.
CREATE PARTITION FUNCTION [pfSourceID](varchar(50)) AS RANGE RIGHT FOR VALUES (
'',
'COKE',
'DRPEPPER',
'MOUNTAINDEW',
'...
0
votes
0
answers
244
views
SSDT building error saying "unresolved reference to Login"
We retrieved source code from a SQL Server 2016 database and made a Visual Studio 2015 SSDT (SQL Server Data Tool) project. The source code contains a file Security\foglight5.sql with the below ...
0
votes
0
answers
38
views
How to throw an error in SSDT Post-Deploy script to fail it's execution?
I'm using Microsoft SSDT to version DB schema. I have a script to autogenerate some triggers and i need to make sure that we don't forget to run it when tables change. I added a part to PostDeploy ...
0
votes
1
answer
231
views
SSDT db-project compare throws "source schema drift detected" for members of sysadmin
We are using SSDT database projects where changes will be done in the dev-DB, then a compare is done between the devDB and the VS-DBproject and selected changes is updated into the VS-project. Lately (...
5
votes
1
answer
11k
views
How to register CLR assembly as trusted in SSDT deployment
I have CLR assembly in SSDT and to deploy that it has to be trusted. What I understand there are 4 options how to do that
First option, use TRUSTWORTHY
EXEC sp_configure 'clr enabled', 1;
...
2
votes
2
answers
2k
views
DACPAC drops existing users and permissions from database when upgrading through SSMS
I'm developing my database through a database project in visual studio, and whenever I need to upgrade the schema of my database I like to use SSMS to do this using a DACPAC.
But whenever I use my ...
3
votes
1
answer
239
views
SQL Server Data Tools -- Stopped connecting to Azure SQL DB
All updates are installed on VS 2017 (15.9.47) and 2019 (16.11.13)
I am trying to perform a data comparison between two DB's via Microsoft’s tool , On Prem and Azure SQL managed instance
Everything ...
1
vote
0
answers
359
views
Prevent Dacpac dropping columns via ALTER_TABLE trigger in TSQL
We're using SSDT to deploy database updates to clients, but sadly they will soon have the ability to add their own columns to tables in their databases. Obviously these won't be included in our model, ...
3
votes
1
answer
714
views
How to tell SqlPackage.exe to create object existence check script?
I have this code that creates a migration script for me:
First Part (Extract)
sqlpackage /a:extract
/of:true
/scs:"Data Source =.; Initial Catalog = Accounts; user id = ...
0
votes
2
answers
2k
views
Which install kit installs sqlcmd.exe?
I recently had to uninstall Visual Studio 2012 and DTS, then install VS 2017 and DTS again. Afterwards, The directory containing sqlcmd.exe was not in my PATH variable. I installed the following.
...
0
votes
0
answers
256
views
Visual Studio Data Tools (SSDT) schema comparison tool does not match database objects
I am using Visual Studio Pro 2019 (16.9.4) and SQL Server Data Tools (16.0.62103.10080) but this happens since the beginning of Visual Studio 2019.
I use the Schema Comparison tool to compare ...
1
vote
1
answer
3k
views
Visual Studio Data Tools (SSDT) schema comparison tool seems like it's not working correctly
I recently started using the SSDT schema and data and comparison tools. For years I was using Red Gate's SQL Compare and SQL Data Compare, but I figured the VS tools are probably enough and figured I ...
0
votes
0
answers
960
views
How can I DENY a SQL Server Database User from seeing tables in a specific schema? VIEW DEFINITION doesn't seem to work
This is somewhat of an X/Y Problem: my original problem is that I want to use SSDT to maintain my database design, with the catch that my database design uses two schemas:
The dbo schema that ...
0
votes
1
answer
249
views
Why does SQLPackage include my table-valued function in deployments when it hasn't changed?
I'm using SQLPackage in TFS to automate an SSDT project/DACPAC deployment with SQL Server 2014. I have a table-valued function that appears in the deployment report and script with every deployment, ...