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
2
votes
2 answers

Data Tools Database Project: Automatically Create Nice Folder Structure

When I import a DACPAC into a VS SS DT project, it creates a very nice folder structure for me: all my schemas are defined under a folder called "Security" and then each schema has its own named folder that contains folders called "Tables", "Stored…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
2
votes
1 answer

How can create a Data Tier Application in visual studio 2013?

I read an article that talked about how to create a Data Tier Applications in Visual Studio 2010, this is the link but i can not create this project in VS 2013, how can i do it? NOTE: my Visual studio is Ultimate
pmn
  • 2,176
  • 6
  • 29
  • 56
2
votes
1 answer

Unable to add database reference for dacpac in Visual Studio 2012 - OutOfMemoryException

I have a dacpac that is 12 MB and which took 45 minutes to generate within VisualStudio 2012. It is for a production Microsoft Dynamics GP (formerly Great Plains) customer database. I was amazed that I was able to get the dacpac created in the first…
EnocNRoll - AnandaGopal Pardue
  • 3,832
  • 2
  • 23
  • 26
2
votes
1 answer

Best practice for setting the DacUpgradeOptions.IgnoreDataLoss flag in continuous deployment?

What is the best practice of setting the DacUpgradeOptions.IgnoreDataLoss property in automatic Data-Tier Application (DACPAC) upgrades? Based on the MSDN documentation (link), if IgnoreDataLoss is True, the upgrade will proceed even if some of the…
Grace Lin
  • 193
  • 9
1
vote
0 answers

Dacpac File and Deploying Data Tier Application Error

I am using the new SQL Server tools with the data-tier project in Visual Studio. I created a snapshot (.dacpac) and I tried to deploy it on a SQL Server instance in management studio but I get the following error. Any clues? My dacpac file and…
Mike Flynn
  • 22,342
  • 54
  • 182
  • 341
1
vote
1 answer

How do I update my Data-Tier Application project to reflect schema changes made in other tools?

I created a data tier application project and imported the initial db schema. How do I update this project when a DBA makes a change to the db schema using SSMS? I want to re-import the database into the project again. This is also relevant in…
djmc
  • 853
  • 9
  • 20
1
vote
2 answers

Error SQL72016: Cannot open database XXX requested by the login. The login failed

We are facing an issue related to bacpac import from local SQL instace to Azure SQL. We generate a bacpac in our local SQL (DAC\140..\sqlpackage) and then we import this bacpac to Azure. We are facing this issue: Error SQL72016: Cannot open…
HLourenco
  • 378
  • 5
  • 19
1
vote
0 answers

Violation of PRIMARY KEY constraint error when upgrading Data-tier Application

I am trying to standardise the schema of my database using a data-tier application. To do this, I have an existing Data-tier application that I want to apply to my database. In attempting to Upgrade the Data-Tier application, I get the following…
Seán
  • 523
  • 2
  • 10
  • 17
1
vote
0 answers

DacServices.GenerateDriftReport throws sql server version Conflict

I have a microsoft sql server 2014 instance with a database "myDB". In SSMS I have registered this database as Datatier application. I have installed the latest dacfx with nuget to my visual studio project. When I hit…
Weissvonnix
  • 731
  • 7
  • 23
1
vote
1 answer

When should use Data-tier Application in our project?

I read some article about Data-tier Application, but i don't understand when we should or better to use it, anyone can give me an example about it?
pmn
  • 2,176
  • 6
  • 29
  • 56
1
vote
0 answers

Why does "DAC" means "Data-tier Application"?

The question is quite simple. I have already googled it but I wasn't able to find anything that could relate this terms. I mean, where does the "C" come from? Does anyone have a hint?
rsfurlan90
  • 31
  • 1
  • 7
1
vote
0 answers

Deploying data-tier applications using inno setup

i need help. There is a data-tier application .dacpac which is need to be deployed at another user's computers using inno setup. Script creates SQL Server instance at target machine and then the data-tier application must be deployed. I think it is…
host.13
  • 108
  • 1
  • 1
  • 11
1
vote
1 answer

SQL Server 2012 Data-Tier Application Template for Visual Studio?

Is there a SQL Server 2012 Data-tier Application template for VS 2010? The version of the template I am using will only allow SQL Server 2008R2. If I open the Management Console in SQL Server 2012 and extract a DAC package, that works and the…
Maess
  • 4,118
  • 20
  • 29
0
votes
1 answer

Good formats for storing configuration information like stored procedure names

In our application data tier we completely rely on stored procedures and web services for Data exchange. We use code like below in loads of pages to execute stored procedures switch(requesttype) { case "GetEmployees": switch…
Deeptechtons
  • 10,945
  • 27
  • 96
  • 178
0
votes
1 answer

Use DAC (data tier application) pack API on Azure

I have a small application that uses the same API as the powerscript examples for upgrading a database from a dacpac (data-tier application). To get it working on a Windows 2008 server without any SQL Server tools installed I had to refernce a lot…
Mark
  • 2,926
  • 3
  • 28
  • 31
1 2
3
4 5