Questions tagged [deployment]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
0answers
164 views

Changing millions of rows of data in production [closed]

We previously made a buggy service deployment that corrupted some of our data in our MySQL database. That change has been rolled back but we’re currently left with tens of millions of rows of ...
-1
votes
2answers
23 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 ...
2
votes
2answers
27 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
3answers
76 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 ...
0
votes
0answers
5 views

ssas : “data type format not supported” with only data source, no data source view

I created a cube in SSAS for my company. This cube encompasses many dimensions and facts, but when I deployed it for the first time I got this error in SSAS : 'data type format not supported'. I ...
1
vote
1answer
116 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 ...
0
votes
0answers
46 views

Deploying schema changes to AWS RDS hosted Databases

With a database hosted in AWS's RDS, the database is only accessible externally if publicly accessible is set to true and the relevant ingress rules are configured to allow connection from a known ...
1
vote
1answer
33 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 ...
2
votes
3answers
2k 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-...
2
votes
1answer
406 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 ...
0
votes
1answer
132 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
2answers
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
1answer
1k 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 ...
1
vote
0answers
58 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
3answers
6k 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 ...
7
votes
3answers
4k 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 ...
0
votes
4answers
544 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 ...
3
votes
1answer
1k 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
2answers
665 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 ...
1
vote
2answers
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. ...
1
vote
0answers
93 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, ...
2
votes
1answer
204 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 ...
-1
votes
1answer
983 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
1answer
80 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
3answers
20k 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 ...
0
votes
1answer
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
3answers
100 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
1answer
72 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 ...
6
votes
1answer
857 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
0answers
152 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 ...
8
votes
2answers
10k 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 ...
0
votes
1answer
1k 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 ...
0
votes
2answers
4k 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
1answer
368 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.)
8
votes
1answer
10k 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 ...
3
votes
0answers
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
1answer
1k 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 ...
4
votes
1answer
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 ...
0
votes
1answer
461 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 ...
2
votes
0answers
826 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 ...
7
votes
3answers
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 ...
1
vote
2answers
515 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 ...
0
votes
1answer
975 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
1answer
202 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 ...
0
votes
1answer
555 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 ...
2
votes
1answer
423 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 ...
2
votes
1answer
970 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 ...
25
votes
2answers
16k views

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

I have worked a couple of times with post deployment scripts and always, intuitively used the build action "PostDeploy", because that is what it is. Now for the first time I try to follow the built-in ...
0
votes
1answer
751 views

Web application for Software as a Service - Shared database or Multiple Databases?

(I am not sure if this is the best place to post this question. If not, please redirect me to the appropriate stack exchange site.) I am looking to deploy a web application for multiple clients. The ...
3
votes
1answer
2k views

SSDT: Create User in a database not being part of the project

I want the user of my SSDT Database Project to be created as a user in another database on the same server and give it permissions to connect and add it to the db_datareader role. I failed to do so. ...