title: The purpose of Visual Studio Database project
body: <p>I have a couple of questions about work process.
  Recently I was entered to the new project with a lot of database activities involved. One of our repositories is Visual studio Database project and has all stored procedures, functions and so on inside it. We don't use it for CI, like Azure. As I understand we publish everything manually.
  The questions are:</p>
  
  <p>1) What is the purpose of the visual studio database project at all? Could you give me some points about it?</p>
  
  <p>2) Should I debug and run all sql code in SSMS or in Visual studio db project during development process?</p>
  
  <p>3) What is the purpose of 'publish' and 'build' functions in it? Are they able to break something in the existing database? How, why and when safetly use them?</p>
  
  <p>I'll be very grateful for providing any tutorials, videos, best practices related to this theme.</p>