Sample Header Ad - 728x90

Why does SQLPackage include my table-valued function in deployments when it hasn't changed?

-1 votes
1 answer
313 views
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, even though the source code and compiled rarely change. Example; I can do a new build and deployment with no source code changes, and my deployment report will look like this (the corresponding SQL script will have the definition matching what's already in the DB): I would expect the deployment to have nothing in it. It's the only object for which this happens, in a project containing thousands of objects. Anybody had an experience like this with SQLPackage/TFS/DACPAC before?
Asked by John Hurtubise (9 rep)
Apr 30, 2021, 12:55 AM
Last activity: Apr 30, 2025, 02:10 PM