title: Do you put your database static data into source-control ? How?
body: <p>I'm using SQL-Server 2008 with Visual Studio Database Edition.</p>
  
  <p>With this setup, keeping your schema in sync is very easy. Basically, there's a 'compare schema' tool that allow me to sync the schema of two databases and/or a database schema with a source-controlled creation script folder.</p>
  
  <p>However, the situation is less clear when it comes to data, which can be of three different kind :</p>
  
  <ul>
  <li><p><strong>static data referenced in the code</strong>. typical example : my users can change their setting, and their configuration is stored on the server. However, there's a system-wide default value for each setting that is used in case the user didn't override it. The table containing those default settings grows as more options are added to the program. This means that when a new feature/option is checked in, the system-wide default setting is usually created in the database as well.</p></li>
  <li><p><strong>static data</strong>. eg. a product list populating a dropdown list. The program doesn't rely on the existence of a specific product in the list to work. This can be for example a list of unicode-encoded products that should be deployed in production when the new "unicode version" of the program is deployed.</p></li>
  <li><p><strong>other data</strong>, ie everything else (logs, user accounts, user data, etc.)</p></li>
  </ul>
  
  <p>It seems obvious to me that my third item shouldn't be source-controlled (of course, it should be backuped on a regular basis)</p>
  
  <p>But regarding the static data, I'm wondering what to do.</p>
  
  <ul>
  <li><p>Should I append the insert scripts to the creation scripts?  or maybe use separate scripts?</p></li>
  <li><p>How do I (as a developer) warn the people doing the deployment that they should execute an insert statement ?</p></li>
  <li><p>Should I differentiate my two kind of data? (the first one being usually created by a dev, while the second one is usually created by a non-dev)</p></li>
  </ul>
  
  <p>How do you manage your DB static data ? </p>