VS 2017 Database project, triggers are missing

Asked Feb 26 '19 at 17:41

Active Feb 26 '19 at 17:41

Viewed 426 times

I created a SQL Server database project and imported my existing database. All looks good except triggers. And when I do a Schema compare, it shows triggers as difference. Am I missing any settings? My database project's database version and target version is same (SQL Server 2016).

For some reason for one of my stored procedure the difference is

screenshot: stored procedure compare

As I just imported the existing database, I was expecting they should be identical.

asked Feb 26 '19 at 17:41

Milan

Related: https://stackoverflow.com/questions/33093876/why-is-ssdt-schema-compare-showing-difference-in-defaultexpressionscript – UnhandledExcepSean Feb 26 '19 at 19:57
@UnhandledExcepSean thanks! Any thoughts on missing triggers? – Milan Feb 26 '19 at 21:20
Not really, the "DefaultExpressionScript" was a PC Load Letter moment for me, so I had to look it up and that led to that other question. – UnhandledExcepSean Feb 26 '19 at 21:24

VS 2017 Database project, triggers are missing

0 Answers0