Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [data-tier-application]

20 questions
14
votes
3 answers

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could occur." However when I use the exact same…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
9
votes
2 answers

DACPAC and database drift: db users are always detected as drift even when nothing has changed

When I include a login and user in my SSDT DB project and try to deploy a DACPAC using the "Block publish when database has drifted from registered version" option, it always detects drift for the database user even when nothing has changed. For…
Matt
  • 405
  • 1
  • 5
  • 11
7
votes
1 answer

Automatic Version increment on Data-Tier Applications

In the project settings of a database project I can set the version number form my data-tier application, however setting this manually is a bit inefficient. I would like to automatically increment the build number, as with other VS projects. How…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
5
votes
1 answer

Export sql azure DB as bacpac file without including data for certain tables

When I export a sql azure database as data tier application from sql server management studio I get the option to tick off certain tables but then these tables are not included in the resulting file. I want to export these tables schemas, but ignore…
Clement
  • 576
  • 1
  • 7
  • 18
4
votes
2 answers

Can independent applications cause roll back to each other's transactions?

I have a database built on SQL Server Application-1 [Legacy App]: Written in C#, and runs transactions on the above database. Application-2 [New application being developed]: Written in Python, and runs transactions on the above…
Amit Tomar
  • 183
  • 1
  • 5
2
votes
2 answers

DACPAC drops existing users and permissions from database when upgrading through SSMS

I'm developing my database through a database project in visual studio, and whenever I need to upgrade the schema of my database I like to use SSMS to do this using a DACPAC. But whenever I use my DACPAC to upgrade the schema of my database, then…
Emil Skovmand
  • 21
  • 1
  • 2
2
votes
0 answers

Data-tier .bacpac import keeps failing

Within a container, I have SqlServer running in a docker container. It was created like so: docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=$1" -p 1433:1433 --name sql1 -v sql1-sqlvolume:/var/opt/mssql -d…
Eric
  • 121
  • 4
2
votes
1 answer

DB design to avoid versioning inconsistencies between the application layer and the database layer

Usually there is a 1-1 mapping between an object in the application layer and a table in the database layer. This coupling leads to complexities whenever there is a database schema change and the application version may not be compatible with the…
Jim
  • 123
  • 5
2
votes
2 answers

SqlDataAdapter vs SqlDataReader for DBAs

Speaking to developers about the use of SqlDataAdapter vs SqlDataReader and reading this: https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader Yields little in the way of explaining the effect on SQL Server of switching from…
Peter
  • 1,500
  • 1
  • 16
  • 36
2
votes
0 answers

Is there a way to programmatically get the version of a .bacpac file without unzipping and inspecting the xml?

The situation is that we get a copy of the latest production bacpac, then restore it locally when setting up our dev environment. During the setup, we do an explicit check for the DacFX dll but target a specific version to warn the user if they are…
Doc Rinehart
  • 21
  • 3
1
vote
1 answer

Should my application utilize database credentials for user login?

I'm working on an application that has an ASP front end and a SQL Server database. The way credential management is currently performed is there is a custom built User Table in the database that stores their email and encrypted password. When the…
Trevor.Screws
  • 111
  • 3
1
vote
1 answer

Is it possible to execute queries in random order?

I have a list of INSERTs, UPDATEs and DELETEs queries. My problem is that I always receive them in the wrong order (random), and I cannot know their original order. Are there techniques to group/execute them in a particular order, so that I always…
Maestro
  • 111
  • 2
1
vote
1 answer

Is there a way to specify which schema the database task "Export Data-tier Application" exports for the other entities besides the tables?

I noticed in the Export Data-tier Application database task, you can specify which schema to export data from in regards to tables, but I also want to exclude certain schemas for the other object types too such as views and stored procedures. Is…
J.D.
  • 40,776
  • 12
  • 62
  • 141
1
vote
1 answer

Data Tier Applications (DAC) on replicated databases

We are exploring options to accomplish 3 things: 1) source control the database, 2) centralize and coordinate all database changes and tie them to application changes, and 3) automate database deployments. I'm considering using DACPACS for this but…
Victor P
  • 113
  • 4
1
vote
1 answer

Connecting to SQL Server database from a .net application

I need to add a new form to an application which requires access to SQL Server to retrieve data from a single view and display it to the user. This application is an enterprise level application with ~1000 users. I assume the best practice is to…
Harvey A.
  • 73
  • 1
  • 3
1
2