I'm with you that it makes the solution slower, but you can just selectively not load it, or use the new light loading feature. You most certainly do not have

I'm with you that it makes the solution slower, but you can just selectively not load it, or use the new light loading feature. You most certainly do not have to make them manually, that can be delegated to a build server. You can also use the dacpac to automatically run integration test and it can run some rudimentary upgrade tests vs previous versions of the dacpac.