I am using azure devops to deploy a database to a virtual machine via deployment groups. I have verified that the system variable path is correct and also that it works when I log into the virtual ...

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 ...

We are using Sql Server database projects to create deployment scripts from DacPac using SqlPackage.exe. We have different SQL Server Filegroups setup in various environments. When deploying we ex...

I have a Visual Studio sql project with a table defined like the following: CREATE TABLE [dbo].[Hoerses] ( [HoersId] INT NOT NULL PRIMARY KEY, [DatePurchased] datetime NOT NULL CONSTRAINT [DF_Ho...

I get this error from SQLPackage: "An item with the same key has already been added" What is the meaning? Google won't help me.. "c:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpacka...

I used maven,Microsoft SQL server management studio 17.SQL server verion is 14.0.1000.169. When i build my project it gives following error and build failed 'sqlpackage.exe' is not recognized as...

I'm trying to use sqlpackage tool for publish thought CMD: sqlpackage /action:Publish /SourceFile:"Database Services\bin\Release\Database Services.dacpac" /TargetDatabaseName:test /Target...

When I attempt to deploy DACPACs via SqlPackage.exe, I encounter the error below : An unexpected failure occurred: Object reference not set to an instance of an object.. Unhandled Exception: Syste...

We have started using SSDT to manage our script deployments. Initially we used Schema Compare and unchecked the parts we did not want to deploy. We now have a need to use Pre and Post-Deploy script...

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...

When trying to apply a DACPAC to an Azure SQL Database I'm getting the following from sqlpackage.exe: *** An error occurred during deployment plan generation. Deployment cannot continue. The El...

I'm trying to create a bacpac file to export my databases to azure. Is there anyway of making it ignore the users, while creating an export package (sqlpackage /a:Export) ?

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...

I've been successfully publishing DACPACs to SQL Server 2008-2012 instances using SqlPackage.exe, as installed by SQL Server Data Tools (and typically found in C:\Program Files (x86)\Microsoft SQL ...

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...

One of our build servers has just been updated to the latest "Microsoft SQL Server Update for database tooling" (version 12.0.60629.0) and is now incompatible with the version of SqlPackage.exe we ...

I am using SSDT (and sqlproj) for our MSSQL projects. We have a few variables we need to set when publishing to each environment. This works great on most of our environments where we assign value...

I'm trying to generate an output dacpac file which I can then deploy to different environments. Until now I was deploying directly from msbuild using the target publish, something like: msbuild db...

I'm using SSDT for Visual Studio 2012 here and using its command-line tool SQLPackage.exe to publish a .dacpac file. I want to publish that to an SQL Server database project. I'm trying to use par...

It should be a simple thing to do, I want to upload/import my database with overwrite option, but I can't find it in the documentation I have to delete it manually and upload with Import.

We have always done our database design and development with VS2012 SSDT using the .sqlproj extension, and deployed to SQL Server using SQLPackage with a DACPAC... or alternatively setup a publish ...

I have a SQL Server Database Project targeting a SQL Server 2012 RC0 database. The project was created in Visual Studio 2010 + SQL Server Data Tools CTP4. (The project type is different than the re...