Questions tagged [data-tier-application]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
44 views

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 ...
3
votes
2answers
85 views

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, ...
2
votes
2answers
470 views

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 ...
2
votes
0answers
128 views

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 ...
1
vote
1answer
212 views

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 ...
0
votes
1answer
45 views

Application slows down during Back up

The Application is 24/7 up Full back up time is 4 am and back up size is 92 gb. It takes one hour to complete the back up. During those time users complain that the application freezes. Just wanted ...
1
vote
1answer
60 views

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 ~...
4
votes
2answers
6k views

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 ...
0
votes
1answer
487 views

Can we use the multiple databases system concept in a single web application?

Am building a simple web based expert application.I have created two databases in the back-end,One database holds user data and the other holds user activity data.Hence it is accessed by a single web ...
1
vote
0answers
1k views

SQL Server - can't import data-tier application from bacpac file (trying to move db + data from Server 2016 to 2014 SP1)

I'm trying to get a workable method to transfer a database schema and data from a SQL Server 2016 install to a SQL Server 2014 install on a different network. It looks like Import/Export Data-Tier ...
4
votes
0answers
1k views

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. ...
1
vote
1answer
74 views

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 ...
1
vote
1answer
50 views

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/...
12
votes
3answers
10k views

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 ...
6
votes
1answer
1k views

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 ...