Question : I am getting below error while deploying package to SSIS catalog on the last step, I am sysadmin […]
Tag: deployment
Dacpac deployment via sqlpackage, “DropObjectsNotInSource=True” is trying to drop .mdf & .ldf
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 […]
Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user
Question : I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands […]
Schema Change/Update script for Database deploy [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Can’t deploy SSAS Tabular Model in Visual Studio
Question : I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I’ve imported the […]
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 […]
Planning Azure SQL Server
Question : I’ve been tasked to prepare Azure SQL database deployment plan and I am struggling with it… I’ve been […]
Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2
Question : Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At […]
Problem with deployment of SQL Server Database on Azure DevOps
Question : We have problem with deploy database via Azure Devops from Database solution: 2022-01-26T09:10:26.6741963Z Unhandled Exception: System.NullReferenceException: Object reference […]
Web application for Software as a Service – Shared database or Multiple Databases?
Question : (I am not sure if this is the best place to post this question. If not, please redirect […]