Database artifacts under source control

Coordinator
Oct 14, 2009 at 6:50 PM

I believe we should include our database artifacts under source control as follows underneath trunk:

  • Database
    • Scripts
      • cust
        • Cccev
          • ckin
    • Functions
      • cust
        • Cccev
          • ckin
    • Stored Procedures
      • cust
        • Cccev
          • ckin
    • Tables
      • cust
        • Cccev
          • ckin
    • Views
      • cust
        • Cccev
          • ckin

This matches our normal (Arena) convention.  Does any disagree or hate the fact that there is extra foldering/layers in there?

 

Developer
Oct 14, 2009 at 8:44 PM

I would personally vote to not include all the "cust\Cccev\ckin" since there will never (knock on wood) be any other paths under "cust" or "Cccev".  I do like:

Database\Scripts

Database\Functions

Database\Stored Procedures

Database\Tables

Database\Views

Coordinator
Oct 14, 2009 at 9:21 PM

Ok, it will mean a little more work when I have to diff all the folders (using WinMerge) but it won't kill me.  We'll use your suggestion and I'll check in all the database stuff now.