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

How to extract MSSQLServer database as .dacpac without VerifyExtraction?

I want to extract a database schema of a MSSQLServer database with Server Management Studio. I use the Extract command "Extract Data-tier Application.." In the database are several references to another database. Because of this I get the following…
Michi-2142
  • 1,170
  • 3
  • 18
  • 39
14
votes
2 answers

How do I find the current version of a SQL Server data-tier application?

We are using a SQL Server Data-tier application (dacpac or DAC pack) and I'm having a hard time finding the current version of the database. Is there a way to obtain the current version using any of these methods: From within SQL Server Management…
Mark
  • 2,926
  • 3
  • 28
  • 31
14
votes
2 answers

ServerConnection.ExecuteNonQuery in SQLCMD Mode

I am using the Microsoft Data-Tier Application framework to create a deployment script based on a DacPackage object. I am attempting to use the Microsoft.SqlServer.Management.Smo.Server class to execute this script... SqlConnection deployConnection…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
9
votes
2 answers

Database versions deployment. Entity Framework Migrations vs SSDT DacPacs

I have a data-centered application with SQL Server. The environments in which it´ll be deployed are not under our control and there´s no DBA in there (they are all small businesses) so we need the process of distribution of each application/database…
Gustavo
  • 263
  • 4
  • 11
6
votes
2 answers

Dacpac must not drop extra columns

I have happily been writing a product which uses a, Sql Server Database Project and life has been good until we discovered a problem in upgrades. While we create tables, stored procedures and various other database artefacts, once deployed at…
Louis Lewis
  • 1,298
  • 10
  • 25
6
votes
2 answers

Where the data-tier application version number is stored in a Visual Studio project?

I have an utility which fills version numbers in AssemblyInfo.cs files. Now I need to implement a functionality to adjust version numbers for Visual Studio Data-Tier applications (DACPAC). I see that I can adjust the number manually if I open…
JustAMartin
  • 13,165
  • 18
  • 99
  • 183
5
votes
1 answer

Complex data migration in the Data-tier Application Framework (DAC Fx)

I am excited to make the leap to using DAC Fx and declarative database development. The major obstacle for me is how to handle complex data migrations across several different versions of the schema. In the old world, we can simply run all of our…
lu.s.benjamin
  • 51
  • 2
5
votes
1 answer

can dacpac be used for managing databases having large volume of data?

Our current database is of nearly 200MB, but once the application goes live, we are expecting this to grow to a large volume.. may be, 20-30 GB of data in that. We are planning to use "dacpac" (generated by database project - SSDT) to deploy on…
Nirman
  • 6,715
  • 19
  • 72
  • 139
5
votes
1 answer

Upgrading DACPACs with DACFx 3.0 API - How to inspect current DAC version of an existing database?

I am currently rewriting my team's database deployment Powershell script to use DACFx 3.0 API instead of 2.0. I've managed to get the DACPAC upgrade to work successfully, using the new Microsoft.SqlServer.Dac.DacServices controller class. The only…
Grace Lin
  • 193
  • 9
4
votes
2 answers

Error deploying a DACPAC to a SQL Azure server

Using a VS2010 SP1 Data-tier application project, I created the simplest database I could: CREATE TABLE [dbo].[Table1] ( column_1 int NOT NULL, column_2 int NULL ) I then successfully built the .dacpac, and verified it by deploying it…
Omri Gazitt
  • 3,428
  • 2
  • 21
  • 27
4
votes
1 answer

Deploying a Data-Tier Project on SQL Azure - Pre and Post Deployment use the master DB

I'm using a Data Tier DB project to deploy on Azure, everything goes fine, the DB and the schema are well created except that during the pre and post deployment it always tries to use the master DB instead of the one I specified under "Deploy - Data…
benj007
  • 71
  • 6
4
votes
1 answer

sqlpackage.exe really slow to deploy a small database

I use VS2015 to build my database project in release mode and then copy the generated .dacpac file to my production server. I am then running a command as follows: sqlpackage.exe /action:publish /targetconnectionstring:"Data…
Remotec
  • 10,304
  • 25
  • 105
  • 147
4
votes
4 answers

Memory usage for bacpac restore to SQL server

I have just restored a .bacpac file into a local SQL server instance (64b v12.0.4213), the backup is from an azure sql instance. It failed a few times with an OOM exception. I switched off everything on my machine and by the end of the restore the…
tigerswithguitars
  • 2,497
  • 1
  • 31
  • 53
4
votes
3 answers

Missing: Utility Explorer in Management Studio 2008 R2

I am trying to use Data-Tier applications and am going through the tutorial here. When I get to step two the tutorial says to open Utility Explorer in the view menu. But it is not there! I looked all over the program for another entry point but I…
johnnywhoop
  • 964
  • 2
  • 7
  • 28
4
votes
1 answer

Can I import BACPAC with data into DB project?

I have a database with data that I want to turn into a Visual Studio 2012 SQL Database project. I tried using "Import->Data-tier application (*.dacpac)..." - I get no errors but no data gets imported (and there is no option to include data). How can…
THX-1138
  • 21,316
  • 26
  • 96
  • 160
1
2 3 4 5