Stack Overflow
Stack Overflow

Questions tagged [data-tier-applications]

A Microsoft data-tier-application also known as 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 or DACPAC.

A Microsoft data-tier-application also known as 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.

63 questions
4
votes
2 answers

Deploying to SQL Azure with Powershell - Is there a way to generate the data-loss warning report?

I have a question regarding Data-Tier Application (DACPAC) upgrade when deploying to a SQL Azure database. When we upgrade the DACPAC manually through the wizard UI, there is a step where we review the data-loss warning report and have the ability…
Grace Lin
  • 193
  • 9
3
votes
3 answers

Data tier applications - Post Deployment

This is such a simple thing that even asking here is making me feel stupid but since I have been stuck on this for long time, I will ask it here. I am working on a data-tier application in visual studio. I have usual things like tables, stored procs…
AR_
  • 127
  • 2
  • 10
3
votes
2 answers

Is there a way to remove blob storage credential from azure database to allow bacpac local restore?

I am trying to export a bacpac from Azure and restore it locally on SQLEXPRESS 2016. When I try to restore it though I get the following errors from the Import Data-tier Application wizard in SSMS: Could not import package. Warning SQL72012: The…
Paul Hillert
  • 111
  • 9
3
votes
1 answer

Possible BUG with BACPAC import and temporal tables

I' using the latest version of SQL Server 2016 Developer edition and SSMS (13.0.15600.2). There is a possible bug in importing Data tier Application (bacpac) that contain any temporal tables and any object (function. view) that references them with…
Sergey Yerdekov
  • 51
  • 3
3
votes
1 answer

Registering Database as Data-tier Application - any change to how SQLPackage deploys?

I have been given the task to create an automated drift report to keep an eye on the health of some of our databases. I have this working and sending out emails etc.... no problem there. I just have some concerns about registering all our live…
Kirky1
  • 68
  • 2
  • 7
3
votes
1 answer

SQL Server - Fails to import Data-Tier Application from SQL Azure

I'm attempting to import a database to my local SQL Server 2012 instance from SQL Azure using the "Import Data-Tier Application" wizard. I simply exported the database to blob storage, then downloaded the file and then selected to import the…
Paul
  • 3,072
  • 6
  • 37
  • 58
3
votes
0 answers

Handling the current version of Data-tier Application in SQL Server 2012

I have some problems with tracking versions of my DACs. I was unable to see the current version of database. Luckily I found this post: How do I find the current version of a SQL Server data-tier application? The second answer did the trick, now I…
Marko Stanojevic
  • 418
  • 5
  • 15
2
votes
1 answer

MSBuild and sqlcmd variables in data-tier applications PostDeployment.sql

Preface I use data-tier application project and SQL CLR Database project to manage Database part of my application. I have 3 different machines (for local, dev/ci/qa and preprod/prod deployment environments accordingly) where Database part should be…
tchief
  • 61
  • 1
  • 5
2
votes
1 answer

Sqlpackage throwing error without details

I am currently working on an application to easily restore a bacpac file. Unfortunately i have the following issue: Sqlpackage throws a error that it cannot import a database because it contains one or more user objects, but when i restore the…
Stefan Bosman
  • 43
  • 4
2
votes
1 answer

How to deal with temp tables when compiling database project

We just created a solution with multiple data projects. We inherited the system and want to do a database cleanup but when we compile some of the databases we get the error that table, id etc does not exist and it occures where temp tables are…
John
  • 21
  • 1
  • 3
2
votes
1 answer

Namespace name 'Dac' does not exist in the namespace 'Microsoft.SqlServer'

I'm trying to get DacFx (latest-v17.1) to work on a machine which has SQL Server 2014 and VS 2013. I tried manually referencing the dll's from the 140/dac/bin folder (I had installed the DacFx17.1 framework) in my console application. I also tried…
ajeesh k
  • 93
  • 8
2
votes
0 answers

Using SignalR with Data-tier Application Framework (DACFx): How to configure and control database changes

I'm trying to develop a workable CI/deployment process for an existing database and web application that uses SignalR. The application architecture is very complicated, with multiple components watching for changes on the database. I want to be able…
The Real Edward Cullen
  • 428
  • 2
  • 11
2
votes
2 answers

Data-Tier Projects and Linked Servers

I'm trying to use a Data-Tier application involving a linked server and running into an odd problem. Here's what I have: 1) A VS2010 solution which includes a Data-Tier project. 2) The Data-Tier project targets an SQL 2008 R2 server. 3) The SQL…
matt
  • 183
  • 2
  • 9
2
votes
2 answers

dacpac - CLR assembly reference path issue

Following is the exact scenario in my database project, where I am creating dacpac to deploy databases on target SQL instance: the database project is having a reference of CLR assembly. TFS build server is used to build the project dacpac is…
Nirman
  • 6,715
  • 19
  • 72
  • 139
2
votes
1 answer

Get the T-SQL inputs & outputs using a dacpac?

FSharp.Data.SqlClient relies on sys.sp_describe_first_result_set to discover the schema of a query's result set. The problem is that this requires a connection to the SQL Server database at design/build time. Is it possible to get this information…
Cameron Taggart
  • 5,771
  • 4
  • 45
  • 70
1
2
3 4 5