Data-Tier application - manual table alter

140 views Asked by At

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 database ?

How the data-tier application changes when I alter something manually bypassing data-tier upgrade ?

The point of my question is: Someone can add a column directly to the table for a customer bypassing a data-tier upgrade. That means our project in visual studio will be outdated. I would like to force anyone to change a database only though data-tier upgrade.

Thanks :)

1

There are 1 answers

1
Ed Elliott On

There isn't a way to do this with Ssdt, the best you can do is to stop future deployments by detecting drift.

Redgate have a product (free version available) that does this it is called dlm dashboard and notifies and allows you to block changes unless they have been pre-approved etc:

https://www.red-gate.com/products/dlm/dlm-dashboard/

Ed