Build repeats on multiple deployments

our scenario requires project changes published several databases:  1 database design, 1 development , 1 demo's.  have separate publish profiles each of target databases project , work fine. 

on 1 of projects have setup, can build project once , apply each of publish profiles - 1 after other - , build not repeated. on project has 3 targets, build, verify ... process repeats everytime publish profile applied though no changes have been made project.  increase time required publishing 4 minutes - 15 minutes.  

one difference between 2 projects first 1 not reference dacpacs (other master), while second references dacpac created project.  because of dacpac reference, build generates hundreds of warnings for: warning 1 exception thrown when ‘maintain compatibility between data types.’ rule applied. exception text is: ‘object reference not set instance of object.’" (an issue reported on forum , later acknowledged as bug correction in tool.)  rebuilds occuring because of existence of warning?  timeframe on when warning resolved?

is there solution avoid rebuilding on each publish?

thanks

hey kazoo,

there couple things @ play in question here, try address them 1 @ time.

first off, design a build action kicked off for every publish action, regardless of whether changes have been introduced or not. should seeing build behavior every project publish regardless of whether has references or not. 1 thing note should kicking off build action, not rebuild, clean , build. expected rebuild takes longer should not happening in case. 1 difference may have static code analysis (sca) set run on build in second project , not first. option can changed in code analysis tab of project properties , disabled default.

now, on second issue point out involves sca - null reference exception getting when build second project. mention, known issue enabling sca run on project contains composite reference database project (or dacpac) can cause these null reference exceptions. have addressed issue since time of last post, fix included in upcoming release. these warnings not causing rebuilds, may contributing factor in performance degradation encountered in second project.

lastly, if willing , able share, send 2 projects can bit of investigation on our side , make sure have indeed fixed sca bug , make sure there no unnecessary rebuilds going on. can zip projects , send them me @ admahood @ microsoft dot com , pass them on appropriate folks investigation.

i hope helps, , let me know if having sca enabled causing decreased performance in second case or if able send projects.

adam

---

adam mahood - program manager data-tier application framework (dacfx)/sql server data tools

SQL Server  >  SQL Server Data Tools