• DNA_DBA (3/17/2011)


    Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. Thanks!

    Yes, definitely find out more... it's a massive step forward.

    You get proper source control without the need to maintain artificial scripts (none of that if exists drop create etc.), deployment is made orders of magnitude easier. As I mentioned in the discussion to another of Jamie's questions, I can do in less than a day what it took a database team 2 or 3 days to do in my last place!

    PS. for maintaining known static data via post deployment scripts, there's a very useful free little tool here[/url] to generate easily maintained, rerunnable scripts from your existing static data for use in your post deployment scripts.