dacpac Questions
4
Solved
I have a Visual Studio database project (DACPAC) which includes a number of SQL Sequences. However when I deploy the DACPAC it always resets the sequence value to the default value included in the ...
Labiovelar asked 1/12, 2015 at 11:34
1
I wonder if there is a F# generative type provider that can be bound to a dacpac file that behave like DbmlFile type provider except for a visual studio database project output.
What I am trying t...
Vallery asked 6/4, 2014 at 22:3
5
Solved
I have 4 sql scripts that I want to run in a DACPAC in PostDeployment, but when I try to build the VS project for 3 of them I get this error:
Only one statement is allowed per batch. A batch separ...
Kennard asked 9/9, 2013 at 12:42
2
Solved
I'm working on setting up a new organization where we are currently using VS 2017 and creating many SQL Server (2016) DB projects.
I've set up a private NuGet server on Azure to be able to use pac...
Feoff asked 22/5, 2020 at 14:58
2
I'm trying to deploy my project in Azure DevOps through IIS website and SQL deployment. However I am struggling with deploying SQL part as I do not have a .dacpac file in my build artifacts. How do...
Mccraw asked 21/9, 2020 at 12:43
3
I noticed that our SSDT projects were building much slower via TFS build definitions than via VS 2013 on my local dev box.
On the build server itself, I can build our largest SSDT project via VS 2...
Tearful asked 12/8, 2016 at 16:50
1
I am getting this error
The imported project "C:\Program Files\dotnet\sdk\6.0.101\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Confirm th...
Rankins asked 21/3, 2022 at 16:5
2
Our application uses a single code base backed by client-specific databases.
What we are trying to achieve is code deployment using usual code push on the IIS website and DB deployments using SQL ...
Rik asked 26/2, 2020 at 8:24
4
Solved
I am using Visual Studio 2013 to manage a .sqlproj file containing our database schema. The schema has been deployed successfully dozens of times.
When attempting to publish to one specific target...
Octahedrite asked 19/2, 2015 at 22:37
2
Solved
I have .dacpac project with Script.PostDeployment.sql:
:r .\SiteType.sql
:r .\Enums.sql
:r .\DebugData.sql
I want to include DebugData.sql conditionaly, only when i publish with DEBUG configuratio...
Anthracosilicosis asked 2/4, 2021 at 9:23
3
I'm developing a .Net-application that would deploy a dacpac on a client machine. For that purpose I would require SqlPackage.exe to deploy the dacpac.
I need a absolute path of SqlPackage.exe to m...
1
Solved
I'm managing a SQL Server database, via DACPAC releases in Azure DevOps.
My project is currently in development but I anticipate development continuing after Prod go-live.
By default I have the Pub...
Jerricajerrie asked 25/9, 2020 at 10:55
3
Solved
We have some automated dacpac deployment code which correctly handles both a CreateNewDatabase and straightforward Update database scenarios in C# using Microsoft.SqlServer.Dac
Now in the CreateNe...
Cupellation asked 25/3, 2017 at 21:40
2
Solved
I am building a database dacpac using sqlpackage on a windows machine. The project contains a reference to master.dacpac
I take the move the dacpac to a linux machine (mssql-server-linux docker im...
Famished asked 31/8, 2018 at 7:31
3
I'm trying to upgrade a remote SQL Server 2012 database using a dacpac, but I'm getting the following message: DacInstance with the specified instance_id does not exist. (Microsoft SQL Server, 3600...
Lawrencelawrencium asked 5/10, 2013 at 21:18
3
In Visual Studio 2012 we have new project type called SQL Server Database Project and when compiled will create a .dacpac output file.
A Google for this term will link it with Data-tier Application...
Saliferous asked 9/12, 2013 at 13:7
2
Solved
I have a VS2013 solution with *.sqlproj project that contains objects specific to this solution. The issue is that this is database common also for other projects.
My problem is to automatically d...
Expansionism asked 8/5, 2014 at 18:45
3
So I've managed to deploy our DACPAC schema via Octopus. I'm using a Deploy.ps1 script interacting with .Net objects just like the article describes.
I'd like to make the deployment process more ...
Salyers asked 10/7, 2015 at 19:33
2
Solved
In PowerShell I'm using Microsoft.SqlServer.Dac.DacServices and Microsoft.SqlServer.Dac.DacDeployOptions to deploy/update a database DACPAC. The problem I am having is finding where to set the SQLC...
Rapallo asked 18/2, 2015 at 16:42
2
Solved
We are trying to work with temporal tables in SQL Server 2016. We are developing the SQL scripts in SSDT 15.1.6 in Visual Studio 2017, but we are experiencing issues when trying to deploy the dacpa...
Primary asked 30/3, 2018 at 15:36
1
During build we generate dacpac files of our database based on a SSDT .sqlproject. This dacpac later gets deployed to production using sqlpackage.
Despite using the /p:DropStatisticsNotInSource=Fal...
Hutt asked 9/3, 2017 at 9:44
2
Solved
I'm trying to deploy a DACPAC to LocalDB 2012 but it's just not having it:
Stack trace is as follows:
==================================
Could not deploy package. (Microsoft.SqlServer.Dac)
----...
Desiccant asked 12/3, 2016 at 0:3
0
Problem
I'm trying to automate SQL deployment including User and Roles. It works when I create the user in Sql Management Studio, but when I deploy dacpack I get SqlException: Login Failed for use...
Older asked 27/10, 2017 at 9:55
2
Solved
We have a database project with views which join to tables in another database. The other database is in a different solution. This failed to build until we added a reference to a DacPac from the o...
Pericardium asked 8/12, 2014 at 19:44
1
Tools: Visual Studio 2015, SSDT
I have an Visual Studio SQL Project which works fine on it's own. I run my build and the dacpac file is in debug\bin\*.dacpac as expected.
The problem is thi...
Guthry asked 10/9, 2017 at 18:46
1 Next >
© 2022 - 2025 — McMap. All rights reserved.