Stack Overflow
Stack Overflow

Questions tagged [database-deployment]

55 questions
1
vote
1 answer

what is the risk of using sparse columns instead of normal relational tables?

I have three table that related to one table,in my new design I want to replace the relationship by using sparse columns. you Can see diagram below. I know I would have Redundancy.but i want to know what is the other risk of this way of design? by…
vesna
  • 403
  • 1
  • 3
  • 13
1
vote
1 answer

How to limit post deployment script to run only once in Visual Studio database project

We have a post deployment script in our visual studio database project. It populates lookup tables with data. The problem is that every time we change schema and generate update script, post deployment script gets appended to the end of the…
fenix2222
  • 4,602
  • 4
  • 33
  • 56
0
votes
1 answer

How do I troubleshoot when VSDBCMD does not deploy, but shows no errors?

I am trying to use VSDBCMD.exe (Visual Studio 2010 version) to deploy the output of a database project. I am including the /dd:+ switch in my command line. Every time I run the command, I get one message: TSD00566 Deployment script generated…
Boris Nikolaevich
  • 1,451
  • 11
  • 21
0
votes
1 answer

How to Deploy Database in Application Installtion

I have an application which uses Sql Server Express Edition to store data. I have a database with 8-10 tables in it. I have mdf and ldf file with me. Now i want to install my application in some other computer, then how to deploy my database with my…
Sandy
  • 11,332
  • 27
  • 76
  • 122
0
votes
1 answer

How to make database name a parameter on deploymanifest?

I am trying to customize default TFS build process by adding a step where a database is deployed using the database project. I followed [these steps][1] and the DB deployment works when the database name is hard code on the deploymanifest file on…
D'Squarius
  • 3
  • 2
0
votes
1 answer

deploying Prisma with Nuxt on heroku

I have spend several days now trying to figure out why my back-end is not working on the online version of my app. I created a Nuxt project that uses Prisma for a very small and simple database. I had already build the "Nuxt part" of the app before…
Marnix Elling
  • 335
  • 1
  • 3
  • 15
0
votes
0 answers

How do I prevent database triggers from being deployed in Azure DevOps when I deploy a DACPAC as part of a release pipeline?

So I figured out how to disable the triggers from being part of a DACPAC, but unfortunately that's just a user level setting in Visual Studio, so I can't save it to source control and deploy the solution with those changes. There's got to be some…
ekolis
  • 6,270
  • 12
  • 50
  • 101
0
votes
1 answer

How do I exclude database triggers from a DACPAC project created in Visual Studio?

I have a database project in Visual Studio, and I need to exclude the database triggers from the generated DACPAC, because one of them is LockdownTriggers which prevents triggers from being altered - and that's causing issues with the other…
ekolis
  • 6,270
  • 12
  • 50
  • 101
0
votes
0 answers

Azure DevOps dacpac release on SQL database with Always Encrypted

I have an SQL database in Azure with always encryption enabled (master key in Azure key vault) to encrypt the data in a particular table. Azure DB is on version Azure SQL Database v12. Somehow, I am not able to deploy my dacpac DB project into it…
Rony
  • 211
  • 2
  • 6
0
votes
1 answer

Using SSDT is it possible to have only selective scripts/objects maintained rather than maintaining the whole database?

Is it possible for me to have a database project to maintain "only" a selective list of DB-objects or scripts rather than importing the entire/whole database? I am tasked with writing an integration between some 3 - 4 third party applications.…
blogs4t
  • 2,329
  • 5
  • 20
  • 33
0
votes
0 answers

How to use SSDT to maintain "changes only" for a subset of a database and not a "whole" database?

Off late, I am searching the internet for a custom solution to automate SQL server database changes deployment. Can I use SSDT to just maintain changes to the database rather than creating a database project and import the entire database.? I have…
blogs4t
  • 2,329
  • 5
  • 20
  • 33
0
votes
1 answer

Examples or Tools for SQL server database deployment automation

Off late I am searching the internet for an automated solution for SQL server database deployments primarily to avoid manual steps of maintaining and deploying sql scripts for deployments. My situation is peculiar. It does not require me to…
blogs4t
  • 2,329
  • 5
  • 20
  • 33
0
votes
1 answer

How do you organise 1 VS Team Services release definition for separate app and db deployment?

I have 2 different Visual Studio solutions. 1 for my asp.net web application and 1 for my database (dacpac). I have included the required deployment tasks under 1 release definition in order to publish my web app and database at the same time. Now,…
Ozmen
  • 43
  • 3
0
votes
1 answer

How to synchronize deployments (especially of database object changes) on multiple environments

I have this challenge. I am the DevOps engineer and a software engineer in a team where months back, the developers moved from having a central Oracle DB to having the DB on a CentOS VM on their individual laptops. The move from a central DB was to…
sage
  • 587
  • 1
  • 8
  • 28
0
votes
5 answers

Visual Studio 2010 SQL Server 2008 Database Project - Custom Updates

In Visual Studio, say you've got a SQL 2008 Database Project and you add a non-nullable column to a table. When you go to deploy the database now, if that table has data in it it should fail. (Right?) How would you write custom logic so that during…
Josh M.
  • 26,437
  • 24
  • 119
  • 200
1 2
3
4