57 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
54
views
In Grate, why do database modifications appear in RunScript but the version in grate version stays the same?
I'm testing Grate for deployment database migrations, and I noticed something I'm not sure about.
When I modify the database (e.g., create new tables, alter tables, insert data):
I see new records ...
0
votes
1
answer
100
views
How to deploy Azure CI/CD to deploy solution that has 2 sqlproj
I have CI/CD pipeline that deploy .Net MVC Web App to web Server.
The release task has
"D:\Deployments\sqlpackage-win-x64-en-162.2.111.2\sqlpackage.exe"
/a:publish /targetservername:test....
1
vote
1
answer
585
views
Azure SQL Database Deployment "ALTER DATABASE failed because a lock could not be placed on database"
I've gotten myself a little stuck.
We've been using Azure DevOps release pipelines to deploy DacPacs to all our internal test database environments. Some of these are Azure SQL databases, and others ...
10
votes
2
answers
1k
views
Cannot Edit Database Connection String in Visual Studio 2022
I have a very unusual bug when trying to connect to a live Azure database via Visual Studio 2022 (17.5.0) using the following connection properties:
Encryption = true
Trust Server Certificate = true
...
2
votes
1
answer
2k
views
How to script and load assemblies list to SQL Server?
My SQL CLR procedure depends on log4net, it depends on System.Web.dll.
When I upload this System.Web.dll :
create assembly [System.Web]
from 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.Web....
0
votes
1
answer
936
views
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 ...
0
votes
0
answers
470
views
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 ...
0
votes
1
answer
875
views
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 - ...
0
votes
0
answers
515
views
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 ...
1
vote
1
answer
1k
views
how to deploy asp.net website in intranet- Copy paste folders
I am new to web developing and some how managed to create one web page with SQL database. Now I would like to deploy my website in localhost server by that users who are having access to that server ...
user avatar
user11171114
1
vote
1
answer
5k
views
When relating two tables, should you do a composite key, or primary/foreign key separately?
What is the industry design standard for representing the relationship between two tables? Should you use a composite key, or a primary key and foreign key separated? Are there performance differences ...
-2
votes
1
answer
68
views
Visual Studio 2015 Database project
I need to exclude some tables from publishing in a database project, the main idea is to publish only a subset of tables depending on the build configuration, if it's Debug I want to publish all the ...
1
vote
3
answers
2k
views
VSTS build - Incremental database deployment in distributed environment
I have a sql server database working with a .net 2015 mvc 5 application. My database code is source controlled using SSDT project. I am using SqlPackage.exe to deploy database to the staging ...
0
votes
1
answer
144
views
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 ...
0
votes
0
answers
71
views
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 ...