Stack Overflow
Stack Overflow

Questions tagged [database-deployment]

55 questions
57
votes
5 answers

SQL Server 2008 R2 Stuck in Single User Mode

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 single user mode). When I connect to it from…
Paul Michaels
  • 16,185
  • 43
  • 146
  • 269
13
votes
3 answers

What is the syntax for adding multiple arguments onto the "Variables" parameter in sqlpackage.exe?

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 pair for an action specific variable;…
gregpakes
  • 4,465
  • 29
  • 43
10
votes
0 answers

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 The target database connection (read-only) is…
abramlimpin
  • 5,027
  • 11
  • 58
  • 97
6
votes
4 answers

How do I deploy an Oracle database?

I have an ASP .NET application that connects to an Oracle or a SQL Server database. An installer has been developed to install a fresh database to an existing SQL Server using sql commands such as "restore database..." which simply restores a ".bak"…
Carl
  • 2,483
  • 4
  • 28
  • 30
6
votes
1 answer

Problems with Database Deployment using VS2010 (Package/Publish SQL tab)

Background: I am using the deployment tools in Visual Studio 2010. I right clicked my project and selected Package/Publish settings. Put all my settings in there ... I am then using "web deploy" to tranfer the files to my remote server running a…
4imble
  • 13,979
  • 15
  • 70
  • 125
6
votes
0 answers

Visual Studio Database Deployment - Script not running in SQLCMD mode

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 execute it, I get the following errors: Error 8 …
Matt
  • 23,363
  • 39
  • 111
  • 152
5
votes
1 answer

Deploying my application that uses Entity Framework and creating databases on the client machine

I created the model in Entity Framework, and then created the database from that model. What would be the best way of doing this in the client machine? If Entity Framework try to connect to the database and find the necessary tables and those do…
Oscar Mederos
  • 29,016
  • 22
  • 84
  • 124
5
votes
2 answers

DACPAC not including composite objects

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 the "Include composite objects" options is selected…
SmudgerDan
  • 413
  • 5
  • 16
5
votes
1 answer

How do you prevent a VS2010 Database Project Deployment from generating a drop database?

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 by the name of the one you are deploying. Under…
Mike Suarez
  • 162
  • 1
  • 8
5
votes
4 answers

Execute SQL Script with .net executable

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 deployment approach to update exe to my client…
Manvinder
  • 4,495
  • 16
  • 53
  • 100
4
votes
1 answer

Update database feature not working in Publish Web dialog in Visual Studio 2012

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 database feature. I entered a connection string…
Mikhail
  • 20,685
  • 7
  • 70
  • 146
3
votes
1 answer

Deploying database and web projects during TFS build process

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 servers are configured on a single domain. I would…
JustAMartin
  • 13,165
  • 18
  • 99
  • 183
3
votes
1 answer

How does an Entity Framework .edmx.sql file generate database in a deployed application?

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, then i designed the model, then clicked the…
Eyal
  • 10,777
  • 18
  • 78
  • 130
3
votes
1 answer

TFS build - VSDBCMD.EXE cannot find deploymanifest

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 difference is that I've done it in another part of…
Andrei
  • 55,890
  • 9
  • 87
  • 108
2
votes
1 answer

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.dll' with permission_set = unsafe; go I see…
ZedZip
  • 5,794
  • 15
  • 66
  • 119
1
2 3 4