Skip to main content
57 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

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 ...
Naila Alissa's user avatar
  • 1
0 votes
1 answer
99 views

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....
user3497702's user avatar
  • 891
1 vote
1 answer
577 views

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 ...
LPQ's user avatar
  • 778
10 votes
2 answers
1k views

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 ...
abramlimpin's user avatar
  • 5,073
2 votes
1 answer
2k views

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....
ZedZip's user avatar
  • 6,592
0 votes
1 answer
927 views

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 ...
Marnix Elling's user avatar
  • 399
0 votes
0 answers
464 views

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 ...
ekolis's user avatar
  • 6,960
0 votes
1 answer
868 views

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 - ...
ekolis's user avatar
  • 6,960
0 votes
0 answers
512 views

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 ...
Rony's user avatar
  • 341
1 vote
1 answer
1k views

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
1 vote
1 answer
5k views

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 ...
Corey P's user avatar
  • 1,125
-2 votes
1 answer
64 views

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 ...
Hardys Perez Bermudez's user avatar
  • 11
1 vote
3 answers
2k views

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 ...
Rupendra's user avatar
  • 588
0 votes
1 answer
142 views

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 ...
Tech with Thiru's user avatar
  • 2,777
0 votes
0 answers
70 views

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 ...
Tech with Thiru's user avatar
  • 2,777
0 votes
1 answer
2k views

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 ...
Tech with Thiru's user avatar
  • 2,777
0 votes
1 answer
41 views

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 ...
Ozmen's user avatar
  • 43
0 votes
1 answer
385 views

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 ...
sage's user avatar
  • 647
-1 votes
1 answer
160 views

I'm trying to build a process of refactoring, testing and deployment of my databases. After some kind of research I found liquibase as a nice tool for managing my database versions. As well similar ...
Mykola's user avatar
  • 618
1 vote
1 answer
714 views

Is there a way to change the encoding for the deploy script generated by Sql Server Data Tools from UTF-8 to ANSI? The problem that I have is that I have a string in a function that contains the ...
Buda Gavril's user avatar
  • 21.7k
0 votes
1 answer
1k views

I am attempting to gain some knowledge and use cases on SSDT Database development and deployments and strugling with some deployment issues. Specifically when using nested views. For some unknown ...
Tsteenbakkers's user avatar
  • 294
2 votes
1 answer
300 views

I have successfully deployed my asp.net web form application on appHarbor and also installed SQL Server. But I don't know how to make database as I could not find any query box of shell where I can ...
Abdullah's user avatar
  • 2,121
0 votes
1 answer
52 views

Suppose I have a dialog box for giving an instance name and I want to see what are the other instances available in the local machine or the server and what if the user has both SQL Server 2005 and ...
user3085636's user avatar
  • 15
1 vote
1 answer
881 views

I need to reformat my computer and reinstall the OS. I have plenty of databases that are connected to sites running on my XAMPP stack. If I copy an paste the data files from the mysql folder into a ...
Hoytman's user avatar
  • 1,832
1 vote
2 answers
798 views

I am supposed to migrate a database into VS2012 sql server project. I have already imported all the schema from the target database. The seed data will be added to the a Post-Deployment script in the ...
BatNetMan's user avatar
  • 23
59 votes
5 answers
95k views

Having executed a DB deploy (from a VS SQL Server database project) on a local database, which failed, the database has been left in a state where it has single user mode left on (the deploy runs as ...
Paul Michaels's user avatar
  • 16.8k
0 votes
1 answer
337 views

Using code first migrations it is trivial to migrate to any given migration by using -TargetMigration [MigrationName]. But how do you rollback to before the first migration? What migration do you ...
Shumii's user avatar
  • 4,629
5 votes
2 answers
4k views

I have a VS2012 database project which includes tables, stored procs, views etc. I then have a second database project which contains a database reference to the first project. I have ensured that ...
SmudgerDan's user avatar
  • 413
1 vote
1 answer
326 views

I've got a question. I'm used to using Teamcity + Database project which was able to deploy the database to all of the DTAP servers. I loved the way that worked - it allowed me to deploy to production ...
Jochen van Wylick's user avatar
  • 5,401
14 votes
3 answers
11k views

I am using SqlPackage.exe for my deployment. I have read the documentation here for the usage of SqlPackage.exe. The documentation only states the synax for one variable: Specifies a name value ...
gregpakes's user avatar
  • 4,565
1 vote
1 answer
595 views

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 ...
vesna's user avatar
  • 423
2 votes
1 answer
2k views

I want to know which port number uses a dbproj(Database Project) in visual studio 2010 to deploy a database in a remote server or how can I find that info thanks!
Jawen's user avatar
  • 1,446
1 vote
1 answer
1k views

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 ...
fenix2222's user avatar
  • 4,750
6 votes
0 answers
3k views

I have a SQL Server 2008 Database Project that I'm attempting to deploy using Visual Studio 2010. When I click deploy, the build works fine, but after it creates the deployment script and begins to ...
MegaMatt's user avatar
  • 23.9k
5 votes
1 answer
2k views

Suppose you have a database project and you do NOT have "Always re-create database" checked off in your Database.sqldeployment settings. And suppose you deploy to a server that already has a database ...
Mike Suarez's user avatar
  • 162
4 votes
1 answer
5k views

I'm developing an ASP.NET Web Forms application under Visual Studio 2012. I'm using Web Deploy and Publish Web dialog for application deploy. I'm trying to deploy a database schema using the Update ...
Mikhail's user avatar
  • 22.1k
0 votes
1 answer
366 views

I have a database project in Visual Studio 2010 that deploys tables and stored procedures to the server without issue. However, none of the index scripts get included in the sql output script and ...
norepro's user avatar
  • 777
5 votes
4 answers
1k views

I have a c# .net application that has been distibuted separately to several clients, Once in a while we add some new features or fix some bugs and frequently make changes in the DB. I use click once ...
Manvinder's user avatar
  • 4,591
0 votes
2 answers
237 views

I NEED YOUR HELP ANY IDEA ANY SOLUTION SCENARIO: An organization suppose Jason industries have its branches in different regions of country. In each branch there is a local database where they ...
Abdul Majid's user avatar
  • 95
3 votes
1 answer
5k views

I have a mixed solution with a couple of Web applications and SQL Database projects. I also have a remote test server with MS SQL 2012 and IIS 7. The TFS build server is on another machine. All the ...
JustAMartin's user avatar
  • 13.9k
0 votes
1 answer
447 views

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 ...
Boris Nikolaevich's user avatar
  • 1,461
1 vote
0 answers
178 views

This may be a stupid question or it might be that I am just not googling with the right strings. I am trying to have my database project generate a deployment script that does not contain any create ...
Ambro's user avatar
  • 73
1 vote
1 answer
331 views

I am trying to build a database project, and then use the output along with VSDBCMD to deploy it to different databases. I have added different sqldeployment & sqlcmdvars files corresponding to ...
Iulian Ilies's user avatar
  • 265
3 votes
1 answer
6k views

I'm building a c# application in Visual Studio 2010, that uses database. To create the database I used Entity Framework model-to-databse approach. So in VS i added a "ADO.NET Entity Data Model" file, ...
Eyal's user avatar
  • 10.9k
1 vote
4 answers
433 views

Just wondering the best way to handle the following.... I want to have a VS2010 database project to keep the schema of my database in the dev, integration test and production environments in sync. ...
Remotec's user avatar
  • 10.8k
0 votes
1 answer
2k views

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 ...
Sandy's user avatar
  • 11.7k
0 votes
1 answer
556 views

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 ...
D'Squarius's user avatar
  • 3
1 vote
2 answers
2k views

I followed How to prepare database for TFS deployment walkthrough and my build script successfully deploys the database at the end of the build process. However, I need the database to be deployed ...
laconicdev's user avatar
  • 6,480
3 votes
1 answer
2k views

I have the following problem. I am trying to customize default TFS build process by adding a step where a database is deployed using the database project. I strictly followed these steps, the only ...
Andrei's user avatar
  • 56.8k
3 votes
2 answers
1k views

I was previously using a database in SQL Server CE. That's kind of easy, because I can have a database in a simple .sdf file and deploy it with my application (either empty or with data already added)....
Oscar Mederos's user avatar
  • 30k

1
2