Question : Powershell deployment script: Executing: C:Program Files (x86)Microsoft SQL Server110DACbinsqlpackage.exe /Action:Publish /SourceFile:********.dacpac /Profile:Release.Publish.xml /TargetConnectionString:server=********;database=********;uid==********;pwd=********;app=********;timeout=900 /p:IgnoreAuthorizer=True /p:IgnorePermissions=True /p:IgnoreRoleMembership=True /p:IgnoreUserSettingsObjects=True /p:BlockOnPossibleDataLoss=False […]
Tag: ssdt
SSIS 2012 metadata not refreshing on re-deploy
Question : I have three systems: DEV, UAT, PROD, all running SQL 2012 Enterprise. I have existing packages that hit […]
SSDT – Deprecated table trigger preventing publish
Question : There is a table trigger that was removed in the past that is blocking SSDT publish preview: This […]
SQL Visual Studio Find and Replace in Publish Profile
Question : We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something […]
SQL SSDT Database Projects: Source Control Lookup Data
Question : Does SQL Server SSDT Visual Studio 2017 Database Projects support Source control data for lookup tables, or do […]
Is automatic disabling of DML triggers possible during SSDT publish?
Question : During ssdt deployment I am concerned about having DML triggers in place on tables that may slow down […]
SQL Server Data Tools for VS 2015 – Anyone using for SSIS development to multiple versions?
Question : According to this link, https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/ the newest version of SQL Server Data Tools – “SSDT for Visual Studio […]
SSDT Publish failing with an error without even running any statements
Question : My publish attempts are failing with this error Msg 205, Level 16, State 1, Line 7572 All queries […]
page_verify none by default
Question : I am reviewing freshly generated scripts out of SSDT publish tools. These projects were built from a default […]
SQL Server – Adding non-nullable column to existing table – SSDT Publishing
Question : Due to business logic, we need a new column in a table that is critical to ensure is […]