Stack Overflow
Stack Overflow

Questions tagged [dac]

Questions utilizing the DAC tag are expected to relate to some aspect of Microsoft Data Tier Applications or DAC. Questions can include the DAC framework or DACfx, schema scripts from DACPAC, and combined data/schema scripts BACPAC. For questions about digital-analog converters, use [digital-analog-converter].

A DAC is a self-contained unit of deployment that enables data-tier developers and DBAs to package SQL Server objects, including database and instance objects, into a single entity called DAC package. Developers can build a DAC package using the Data-tier Application project system in Visual Studio, whereas SQL Server Management Studio (SSMS) users can extract a DAC and generate a DAC package file for an existing database.

A DAC package can be deployed to an instance of SQL Server to create a new DAC instance. The DAC deployment installs a new database on the instance, creates the database objects, and creates the logins associated with the users of the database. If a previous version of the DAC is already available, the DAC package can be used to upgrade the existing DAC instance to a newer version.

Questions utilizing the DAC tag are expected to relate to some aspect of Microsoft Data Tier Applications or DAC. Questions might also include related subjects such as the DAC framework or DACfx, as well as schema scripts known as DACPAC, and combined data/schema scripts BACPAC.

178 questions
4
votes
1 answer

Copy SQL Server 2012 database to SQL Azure via BACPAC (for Continuous Integration)

I'm creating a continuous integration MSBuild script which copies a database in on-premise SQL Server 2012 to SQL Azure. Easy right? Methods After a fair bit of research I've come across the following methods: Use PowerShell to access the DAC…
Nick Evans
  • 3,279
  • 2
  • 25
  • 21
3
votes
1 answer

Is the Sql Azure Dac Import/Export service WCF or REST or something else?

I downloaded the example application and was surprised to see quite complex web request building and handling. Unfortunately I have not been able to find even one scrap of documentation about the service. I tried using AddServiceReference in VS and…
Rabbi
  • 4,622
  • 9
  • 35
  • 45
3
votes
1 answer

DacFx and Custom DeploymentContributor (AgileSqlClub.DeploymentFilterContributor)

I've tried at least a dozen or so ways to get the module to load and work but still get the same error:  Error SQL0: Required contributor with id 'AgileSqlClub.DeploymentFilterContributor' could not be loaded. I've tried to run it with…
user3536680
  • 31
  • 1
3
votes
1 answer

Error SQL71624: The permission 'CONNECT' is not valid for the target object 'guest' in Microsoft Azure SQL Database v12

I have a SQL database created and I am trying to deploy/move that database to the Azure Cloud by using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio. But I have ran into an error after trying to deploy it. I am using the…
soccerstarz502
  • 33
  • 4
3
votes
1 answer

How to fix Dac Deployment error "InternalDeploymentPlanModifier could not be instantiated"

I try to deploy a .dacpac package programmatically using this code: var dacServices = new DacServices(myConnectionString); using (var bacPacPackage = DacPackage.Load(dacPacFilename)) { var options…
Felix
  • 43
  • 6
3
votes
1 answer

SSDT skips NOCHECK constraint in compares and publishes

For some reason when using SSDT to either compare or modify a Table Foreign Key the software does not do anything to change the NOCHECK constraint set on the Foreign Key. This is the scripted setup for the table Foreign Key: TABLE: ALTER TABLE…
user5855178
  • 567
  • 1
  • 7
  • 17
3
votes
2 answers

Delta-sigma DAC from Verilog to VHDL

The code below implements a Delta-sigma DAC in Verilog, from a Xilinx application note and I want to write equivalent VHDL code. I don't know anything about Verilog and I'm beginner in VHDL so I had to make a lot of guesses and probably beginner…
Giovanni Funchal
  • 8,934
  • 13
  • 61
  • 110
3
votes
1 answer

stm32L4 : How to generate triangular wave using DAC DMA, uneven slopes

I am trying to generate a triangular wave of frequency 8kHz using DAC and DMA. DAC is triggered using a timer so that the DAC speed will be 1 MSPS. I am working on stm32L476 discovery board. I am using stm32CUBEMX for code initialization. My…
user8398475
  • 61
  • 2
  • 7
3
votes
1 answer

Can't Deploy to Azure SQL Database inside a Azure Failover Group using DacFX

I can't deploy to an Azure SQL Database inside an Azure Failover Group using the Read/write listener endpoint from VS2015/17 database project publish or using DACFx? I'm using a contained user with appropriate permissions and have proved it works by…
kmkelly
  • 56
  • 4
3
votes
1 answer

Finding data type information for certain objects in DacFx API

I'm writing a code generation tool against Sql Server Data Tools and I need to be able to get the data type for: View Columns Computed Columns on a table Where is this information? For tables (with the exception of computed columns), it's…
user1935361
  • 442
  • 3
  • 15
3
votes
0 answers

What exactly does DAC do? (Data - tier Applications)

So I'm trying to figure out the purpose of DAC, so I tried reading here; But I am very overwhelmed by the definition (Since technically, I'm still a newbie anyway) Could anyone explain it to me in a very simple manner? based from my understanding,…
Mr.J
  • 430
  • 2
  • 10
  • 30
3
votes
1 answer

DacFx DeploymentPlanExecutor OnExecute not called

I'm trying to program a custom DeploymentPlanExecutor using Microsofts DacFx 3.0 but the OnExecute-Method is never called. If I use an identical DeploymentPlanModifier instead, OnExecute() is called as expected. No matter whether I add the…
user4758246
  • 575
  • 5
  • 13
3
votes
1 answer

How to setup schema compare file so that it always ignores a specific db schema?

I have two SSDT projects targeting the same database. When I use Schema Compare feature from any of the projects, it detects the other project's objects as being non-existent and sets them for deletion. I cannot merge the two projects into one as I…
Crono
  • 10,211
  • 6
  • 43
  • 75
3
votes
2 answers

Turning on TRUSTWORTHY with a dacpac

I am creating a database with an SSDT database project and deploying as a dacpac. A .NET assembly is part of the project and during deployment installation fails with the following error message: CREATE ASSEMBLY for assembly 'xyz' failed because…
Swoogan
  • 5,298
  • 5
  • 35
  • 47
2
votes
1 answer

Acumatica Delete from Graph

I would like to delete a record from a graph, I can easily add one, but what is the syntax for deleting one with filter on Immatriculation field : Example do add ZVEHICULEGRAPH graph = PXGraph.CreateInstance(); ZVEHICULE dac = new…
Xavier LARTEM
  • 77
  • 5
1
2
3
…
11 12