Post reply

How do you do logical/physical ERD''s?

  • November 8, 2006 at 9:06 am

    #175109

    I'm curious how you do your ERD's for your databses.  Assuming you have at least a separate development & production environment.  When you make changes to development, do you have a separate ERD for development and another ERD for production, or do you just keep a production ERD?

    I'm curious how you handle this in your respective companies.

    Thanks

    -Dave

  • November 9, 2006 at 12:27 pm

    #670916

    Each developer has their own personal SQL Server on their system. There is not a single unified development system. Pre-production (test) is backfilled from production every Monday and is controlled by the QA department with frequent restores and regression testing. So maintaining an ERD would not make sense as it is never static long enoung.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply