Questions tagged [deployment]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
11 views

Getting error while deploying PieCloudDB

When installing PieCloudDB on KVM, it prompts that foundationdb is incompatible with the cc container and cannot be deployed. How can I solve this problem?
heihei Li's user avatar
0 votes
0 answers
14 views

How can I automate trigger deployment to Mongo Atlas?

I have a couple of triggers on a Mongo Atlas cluster that I want to deploy to a number of databases on a different cluster. Is there any way to do this automatically, through a script or something ...
SQB's user avatar
  • 465
0 votes
0 answers
23 views

Managed database or docker image with data-volume?

I've mostly used managed database (AWS RDS) for production. I was fiddling with docker and was wondering if it's a good idea to have containerised postgres database with data-volume? I feel it may not ...
Indyarocks's user avatar
0 votes
0 answers
28 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 ...
Ivan Koshelev's user avatar
0 votes
1 answer
62 views

How to reset a cloud Postgres DB as if it was just created before each demo deployment?

I was using Heroku for projects in development. Heroku has a great option to reset Postgres DB: https://devcenter.heroku.com/articles/managing-heroku-postgres-using-cli#pg-reset. Now I'm using other ...
Fred Hors's user avatar
  • 101
5 votes
1 answer
9k 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; ...
Muflix's user avatar
  • 1,099
1 vote
0 answers
55 views

Database deployment rollback

I am looking for documentation on how this is done in MS SQL. I've done some searches and haven't found how to do this. There is documentation on how to set up HA and DR... But this specific process I ...
greektreat's user avatar
2 votes
1 answer
156 views

Version control for Oracle databases

I'm setting up a version control for several databases. There are some objects like functions/procedures/packages that appear in all the databases, that is, each such object has an identical instance ...
hajduk's user avatar
  • 21
0 votes
1 answer
238 views

Problem with deployment of SQL Server Database on Azure DevOps

We have problem with deploy database via Azure Devops from Database solution: 2022-01-26T09:10:26.6741963Z Unhandled Exception: System.NullReferenceException: Object reference not set to an instance ...
axdna's user avatar
  • 111
6 votes
3 answers
9k views

Command to validate a postgresql configuration file?

I am generating postgresql configuration files via ansible, and putting them in /etc/postgresql/XX/main/conf.d/whatever.conf. I accidentally made a syntax error and broke my postgresql, requiring ...
Amandasaurus's user avatar
1 vote
1 answer
156 views

What's the best way to deploy changes to several databases on multiple Postgresql Databases servers

I was wondering if there is a better way to deploy changes to several Postgres databases on multiple servers. I have been using Ansible for this task, I have a playbook that basically copies the ...
Javier Galarza's user avatar
1 vote
0 answers
608 views

DACPAC: Altering primary key results in rebuilding tables during deployment

Question: Is there any better way to avoid rebuilding of table when clustered Index column is changed Details: We have Database project with all default settings. There are tables with primary key ...
sanjay's user avatar
  • 11
-1 votes
2 answers
100 views

Tool to Execute SQL Server Scripts and Automatically Recognize and Prompt for Scripting Variables [closed]

I have a folder of scripts that contain multiple objects and jobs that I roll out every time I deploy a new SQL Server Instance. The scripts utilize scripting variables, as an example, here is an ...
SE1986's user avatar
  • 1,960
2 votes
2 answers
635 views

How do you update one side of a MySQL master-master replication setup?

I have a master-master (circular) replication configured between two MySQL servers, call them West and East. There is also a web app that interfaces with each DB, also on its own West and East server,...
pineconesundae's user avatar
2 votes
3 answers
420 views

Retain indent formatting when compiling a stored procedure without Data Studio

When I compile a stored procedure using CLPplus console (or even in dBeaver), all indentation is stripped out. Only when I compile in Data Studio is the formatting retained, but I would like to ...
Jake v1's user avatar
  • 73
1 vote
1 answer
598 views

Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user

I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands that run the sqlpackage.exe commands to publish the database. I am using the ...
Wai Lun Poon's user avatar
1 vote
1 answer
78 views

Planning Azure SQL Server

I've been tasked to prepare Azure SQL database deployment plan and I am struggling with it... I've been given following information: 2 million transactions will arrive to database daily throughout ...
Mifodiy's user avatar
  • 11
4 votes
3 answers
9k views

How to unpack a DACPAC?

When I right-click on a DACPAC file in windows explorer, I don't have an option to "Unpack" the file, like this document indicates: https://learn.microsoft.com/en-us/sql/relational-databases/data-...
Greg's user avatar
  • 574
5 votes
1 answer
2k views

SQLPackage resets database recovery model

I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it ...
JackLock's user avatar
  • 468
0 votes
1 answer
600 views

Error while deploying package to catalog

I am getting below error while deploying package to SSIS catalog on the last step, I am sysadmin and have access to the below views. Can someone help please. Let me know if you need more info. Any ...
Finny Thomas's user avatar
4 votes
2 answers
3k views

Assembly deployment with permission UNSAFE or EXTERNAL_ACCESS using asymmetric key

When we are trying to deploy an assembly with PERMISSION_SET=UNSAFE or EXTERNAL_ACCESS, we are getting following error message by SQL Server: CREATE ASSEMBLY for assembly 'System.ServiceModel....
Murali Dhar Darshan's user avatar
2 votes
2 answers
2k views

Disk block size for mongodb deployment

Why does Mongodb production notes have no recommendations about the disk block size? AFAIU, disk block size would have a considerable impact on a throughput intensive application. Does disk block size ...
ankshah's user avatar
  • 143
1 vote
0 answers
74 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
Ejaz Sarwar's user avatar
1 vote
3 answers
12k views

Can't deploy SSAS Tabular Model in Visual Studio

I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
julmoser's user avatar
10 votes
3 answers
7k views

SSDT Drop and Recreate Tables when nothing has changed

We have a Visual Studio Database Project consisting of about 129 Tables. It is the primary database for our Internal Web Based CRM/Call Centre product, which is still under active development. We ...
OJay's user avatar
  • 351
1 vote
4 answers
1k views

SSIS deployment failed - working with files

I've developed a simple SSIS package that will open a csv file, select a number of column, add two derived columns and then copy the results to a file. This works within visual studio (even if it ...
Exostrike's user avatar
  • 173
3 votes
1 answer
2k views

Dacpac deployment via sqlpackage, “DropObjectsNotInSource=True” is trying to drop .mdf & .ldf

Powershell deployment script: Executing: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe /Action:Publish /SourceFile:********.dacpac /Profile:Release.Publish.xml /...
Patryk Patkowski's user avatar
2 votes
2 answers
1k views

Deploy materialized view with database link using another user

Our database deployment process logs in as sys to deploy database objects. We ran into a problem when we wanted to deploy a private database link for another user (AU). Our solution was to: Create ...
Leigh Riffel's user avatar
  • 23.9k
1 vote
2 answers
2k views

Deploying a cube where database name has been changed

I have an issue where I have renamed the database for which my cube deploys to from, say, SalesAndStuff to Sale. This has been no issue, I have changed the database name in Management Studios etc. ...
Cenderze's user avatar
  • 197
1 vote
0 answers
101 views

Builds and deployments to 300+ databases utilizing SSDT/VSTS

I have built a database project within SSDT for Visual Studio 2017. I have also created Publish profiles that succesfully deploy to our dev, QA, staging, and production databases with no issue, ...
PicoDeGallo's user avatar
  • 1,564
2 votes
1 answer
340 views

AlwaysOn Availability Groups Dev, QA, and Staging Environments [closed]

Our company would like to implement Always On Availability Groups. The Final PRODUCTION Plan is for Primary Replica in one state, and Secondary Replica in another state location. The secondary replica ...
user avatar
-1 votes
1 answer
1k views

Slave Connection 1130

So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following: +------------------+...
David Rhoderick's user avatar
2 votes
1 answer
195 views

Database upgrade script for removing columns

So I have a SQL database project which tracks our application's database schemas, stored procedures, etc. It also has deployment script generation sections, including pre- and post-deployment scripts. ...
Nate Diamond's user avatar
4 votes
3 answers
23k views

Cannot Deploy SSIS Package in SQL Server Data Tools 2015 (Destination server name doesn't allow password entry)

I'm extremely frustrated. I'm using SQL Server Data Tools 2015. I have an Integration Services project and I want to deploy a single package of this solution to SQL Server 2012. I've set the ...
Brad's user avatar
  • 943
0 votes
1 answer
2k views

Data Migration and altering tables in one SSDT deployment script

I'm using SSDT and MS SQL Server 2012. And I need to handle next cases in one deployment script: --1 CREATE TABLE Table1 (Col1 INT) --2 INSERT INTO Table1(Col1) SELECT SomeCol FROM SomeTable --3 ...
whitebeast's user avatar
1 vote
3 answers
190 views

Primary node becomes secondary before application is deployed and moved into AAG

We have a small database that was created on a primary node. But by the time the application was deployed and it was time to move the db into the AG I noticed that it became the secondary node. For ...
buddinggeek's user avatar
0 votes
1 answer
109 views

SSAS Deployment Wizard - Issue with multiple connection strings

I've observed an issue with the SSAS Deployment Wizard. I have two environments DEV and PROD. A few weeks ago when I deployed anything on PROD I had one connection string only there to PROD (similar ...
Tomasz Wieczorkowski's user avatar
7 votes
1 answer
1k views

Is there a way to give GRANT OPTION recursively for subsets of permissions?

In SQL Server, I would like to create a role that has the ability to manipulate database objects as well as create other roles and grant those roles subsets of its permissions. CREATE ROLE ...
SolsticeShard's user avatar
1 vote
0 answers
193 views

Unable to deploy single SSIS package into SSISDB when referencing parameters

I'm attempting to deploy a single package into an Integration Services Catalog using the project deployment model in SQL 2016. This however is giving me some grief, as I've configured environmental ...
ozMoses's user avatar
  • 21
9 votes
2 answers
14k views

DACPAC and database drift: db users are always detected as drift even when nothing has changed

When I include a login and user in my SSDT DB project and try to deploy a DACPAC using the "Block publish when database has drifted from registered version" option, it always detects drift for the ...
Matt's user avatar
  • 395
0 votes
1 answer
2k views

Enable Service Broker when deploying solution

I'm having an issue deploying the latest build of a database solution after creating some service broker objects. I am thinking that it could be related to not having service broker enabled on the ...
TaylorN's user avatar
  • 145
0 votes
2 answers
5k views

Deploying and running SSIS packages to SQL Server with protection level EncryptSensitiveWithPassword

I have an SSIS package that connects to both a SQL Server instance and a MySQL instance so it can feed data from the SQL Server to the MySQL instance. When I deployed this package to the SQL Server ...
Michael Plautz's user avatar
3 votes
1 answer
433 views

Can SSDT deploy SQL server service broker objects?

Can SQL Server Data Tools (SSDT) deploy sql server broker objects? (So contacts, message types, services, queues and so on.)
Courtney's user avatar
11 votes
1 answer
14k views

How to prevent SSDT publishing from dropping columns

I want to create a publishing profile that DOES a complete schema comparison and publishing BUT does not drop any tables or any columns that have been removed between the old and new version. I am ...
Magier's user avatar
  • 4,787
3 votes
0 answers
2k views

Best practices for deploying and updating SQL Server as part of code deployment

I am a (windows) developer trying to determine the best approach for publishing DB schema changes requiring data transformations as part of my code releases. I have tried googling but did not find ...
R Andersen's user avatar
1 vote
1 answer
2k views

Enable TDE When Publishing DACPAC

In the database properties in Visual Studio there is a checkbox for encryption. I'm not sure if I check this if it will enforce encryption when doing a DACPAC deploy. What I would really like to do is ...
Chris's user avatar
  • 113
4 votes
1 answer
3k views

Howto create useful dacpac versioning along with SSDT deployment?

It took me almost one day to go through lots of articles and blogs to realize check-in driven continuous integration with SQL Server Database Projects (SSDT) using TFS and msbuild. Now once this is ...
Magier's user avatar
  • 4,787
0 votes
1 answer
727 views

Is automatic disabling of DML triggers possible during SSDT publish?

During ssdt deployment I am concerned about having DML triggers in place on tables that may slow down performance of table recreation a lot. We are facing the issue that the column order in the ...
Magier's user avatar
  • 4,787
2 votes
1 answer
1k views

Howto create a detailed report of all actions by publishing with sqlpackage.exe?

When publishing ssdt projects from visual studio I realized that a "deploymentreport.txt" file is created on hard disk. sqlpackage.exe can be executed with the action "DeployReport" that creates a ...
Magier's user avatar
  • 4,787
7 votes
3 answers
3k views

Property class Length Annotation PersistedResolvableAnnotation

I am trying to deploy an ssdt project using sqlpackage.exe utility. I get the following error (in German): Fehler bei der Erstellung des Bereitstellungsplans. Die Bereitstellung kann nicht ...
Magier's user avatar
  • 4,787