Questions tagged [deployment]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
25 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 ...
2 votes
1 answer
79 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 ...
  • 21
0 votes
1 answer
73 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 ...
  • 101
3 votes
2 answers
813 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 ...
1 vote
1 answer
64 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 ...
1 vote
0 answers
209 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 ...
  • 11
-1 votes
2 answers
37 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 ...
  • 1,575
2 votes
2 answers
332 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,...
2 votes
3 answers
268 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 ...
  • 73
1 vote
1 answer
416 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 ...
1 vote
1 answer
48 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 ...
  • 11
4 votes
3 answers
5k 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://docs.microsoft.com/en-us/sql/relational-databases/data-tier-...
  • 532
3 votes
1 answer
1k 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 ...
  • 440
0 votes
1 answer
290 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 ...
2 votes
2 answers
2k 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....
2 votes
1 answer
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 ...
  • 143
1 vote
0 answers
63 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 ...
1 vote
3 answers
9k 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 ...
9 votes
3 answers
5k 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 ...
  • 331
0 votes
4 answers
744 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 ...
  • 143
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 /...
2 votes
2 answers
841 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 ...
  • 23.6k
1 vote
2 answers
1k 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. ...
  • 199
1 vote
0 answers
100 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, ...
  • 1,544
2 votes
1 answer
241 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 ...
's 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: +------------------+...
2 votes
1 answer
109 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. ...
4 votes
3 answers
21k 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 ...
  • 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 ...
1 vote
3 answers
120 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 ...
0 votes
1 answer
78 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 ...
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 ...
1 vote
0 answers
164 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 ...
  • 21
8 votes
2 answers
12k 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 ...
  • 375
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 ...
  • 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 ...
3 votes
1 answer
406 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.)
10 votes
1 answer
13k 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 ...
  • 4,645
3 votes
0 answers
1k 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 ...
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 ...
  • 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 ...
  • 4,645
0 votes
1 answer
593 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 ...
  • 4,645
2 votes
1 answer
897 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 ...
  • 4,645
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 ...
  • 4,645
1 vote
2 answers
738 views

SSDT table column order

I realized that the behaviour of SQLPACKAGE.EXE changes depending on what changes have been made to a table schema: Adding a new column at the end of the table: "Table is changed" Removing a column ...
  • 4,645
0 votes
1 answer
1k views

Staging MySQL databases

I'm building a Web/Web service application based on a number of (MySQL) databases. The databases are all built from externally derived data from dozens to hundreds of sources. My general plan is to ...
0 votes
1 answer
221 views

Howto remind and restore recovery mode during SSDT deployment?

Due to deployment of a SSDT database project I would like to be able to switch the target database's recovery mode from FULL to BULK LOGGED and back after the deployment finished in order to do any ...
  • 4,645
0 votes
1 answer
696 views

SSDT Publish Window: What does checkbox ENABLE mean?

In the Visual Studio 2015 SSDT "Advanced Publish Settings" Window, Tab General, "Advanced Deployment Options" there are several checkboxes in the column "ENABLED" we can check or uncheck. Most of the ...
  • 4,645
2 votes
1 answer
548 views

Run aspnet_regsql.exe from SQLCMD Post-Deployment Script

I am trying to create a Post-Deployment script in SSDT that will include the creation of an ASP.NET Session State database to make sure everyone has this thing in place after deployment of my database ...
  • 4,645
2 votes
1 answer
1k views

Post data deploy in SSDT

I need to create post deployment script which will upload data from .csv file to my database. But I can't understand how can I do this. When I tried to deploy my project on my server I receive this ...