I have an SSDT Database project, to which I have added a new field. If I use that DACPAC to generate a new database on my local server, the new field is all present and correct - which is great.
However, if I upgrade a database, then at the point when the system is checking for differences, it reports back that there have been no changes (misses my new field), and of course my new field doesn't appear.
Does anyone know why that would be, or have any thoughts on what it is that I might be doing wrong?