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

Importing Data Tier Application Turns Suspect After Server Restart

Whenever I export a data tier application from my Azure Sql Database and then Import that .bacpac file from that export into my local Sql Server after the machine is restarted the database is marked as suspect. Before restarting the machine the…
dmoore1181
  • 1,793
  • 1
  • 25
  • 57
0
votes
1 answer

Why does a SQL Azure DACPAC upgrade (via a PowerShell script) consistently take 30min to complete

I created a PowerShell script to upgrade a SQL Azure instance with my latest DACPAC (taken from http://msdn.microsoft.com/en-us/library/ee634742.aspx). What I have experienced when running my PowerShell script is that it consistently takes…
Andrew Thompson
  • 2,396
  • 1
  • 21
  • 23
0
votes
1 answer

Updating production database via DACPAC upgrade

Using a DACPAC to upgrade a data-tier application database is an 'in-place process' as per the documentation. My question is, how do you go about updating your production databases? Do you just apply the DACPAC directly to the production database,…
digital_fate
  • 567
  • 1
  • 5
  • 15
0
votes
1 answer

DACPAC error if External tables and data sources present at source db

Getting the following error on DACPAC deployment to Azure Synapse SQL Pools: Error SQL72018: SqlExternalDataSource could not be imported but one or more of these objects exist in your source. This has started since my colleagues created couple of…
ASHISH M.G
  • 522
  • 2
  • 7
  • 23
0
votes
0 answers

SQL Server Database Project allowing unsupported functions for target platform

I have a SQL Server database project which is set to target SQL Server 2008 as its Target Platform. In one of my stored procedures, I have code as follows: DECLARE @yearEnd date SET @yearEnd = datefromparts(@reportingYear,8,31) The particular…
Laurence Frost
  • 2,759
  • 3
  • 28
  • 45
0
votes
1 answer

Need to specify the Microsoft.Data.Tools.Schema.Tasks.Sql version explicitly in a Visual Studio database project

My situation is a bit complex, I hope I can explain it correctly: I have a Visual Studio solution which I'm using to build a WiX installer. This installer, among other things, deploys an SQL DB schema through a dacpac. This dacpac is generated by an…
Ioan H
  • 111
  • 9
0
votes
1 answer

Is there a simple way to copy a SQL Azure Database locally on SQL Server 2014?

I have created a bacpac file through the Export option of Azure. Then, I tried to import the bacpac file into SQL Server installed locally on my pc, selecting in SQL Server Management Studio, the “Import Data-tier Application…” feature. The import…
Enrico
  • 1
0
votes
0 answers

Programmatically Interact with a Visual Studio Database Project from C# Code

How would one go about programmatically interacting with a Visual Studio Database Project from C# code? I would like to do the following: given a live database, create a database project that represents the schema of that database given an existing…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
0
votes
1 answer

Dacpac not upgrading through code properly

we have a central database and need to upgrade our local database. We are using dacpac to do this. Basically we make the changes to the database on the server. we then create a dacpac. It gets put into the deployment package. When the client runs…
Sirus
  • 382
  • 1
  • 8
  • 35
0
votes
1 answer

Data-Tier application - manual table alter

Let's say I registered my Data-Tier Application into SQL Server 2014. Is there a way how can I disable manual altering of tables? So I can force developers to publish new version of data-tier application instead of manual altering any table in the…
wh1sp3r
  • 1,640
  • 2
  • 17
  • 30
0
votes
1 answer

SQL Server 2008 R2 - Objects not supported in a DAC geography

Using SQL Server Management Studio, I'm trying to create a DACPAC by right-clicking the db -> Tasks -> Extract Data-Tier Application. When I get to the Validation and Summary screen I get some errors because sql spatial data types aren't supported.…
Heinrich
  • 1,711
  • 5
  • 28
  • 61
0
votes
2 answers

Good Data Tier Dev & Design: What are the common bad practises in data tier development?

I am currently researching the best practises (at a reasonably high level) for application design for highly maintainable systems which result in minimal friction to change. By "Data Tier" I mean database design, Object Relation Mappers (ORMs) and…
holsee
  • 1,974
  • 2
  • 27
  • 43
0
votes
0 answers

Deploying DAC Package to SQL Server 2008 R2

Im new in SSDT and faced with the following problem: In VS 2012 I have created new Database Project and added few Tables. SQL Server 2008 was selected as target platform. Then I made project snapshot and tried to deploy it on 2008R2 SP2 server. In…
landless
  • 133
  • 2
  • 8
0
votes
1 answer

Can a data-tier application coexist with a manually-managed database?

We have a large production database that is using a custom version control that allows for seamless upgrades when the schema changes (each change script is versioned). Everything works well. Can we use the data-tier application programming model…
David Airapetyan
  • 5,301
  • 4
  • 40
  • 62
0
votes
1 answer

Data-tier in n-tier architecture

I have a question about data integrity. One important role of "data tier" is ensuring data integrity .Is this achievable without the help of "business layer"? Thanks.
xtiger
  • 1,446
  • 2
  • 15
  • 33
1 2 3
4
5