How to you handle the contents of lookup tables that should be treated as "code" rather than data?
+1
A:
There is currently no good support in VS for Database Developers for managing reference data.
There is a good post at MSDN that proposes a work around for this missing feature that uses a temp table and a post deployment script to merge changes to the reference data at deployment time.
Essentially your reference data exists as a static set of insert statements into your temp table and then the merge keeps the live tables up to date.
I've been using the approach on a large fully CI project for the last five months or so and found it works well.
I've also got my fingers crossed that they will add better support for this in VSDB vNext.
David Hall
2010-02-06 01:13:22
Worked like a champ.
Jonathan Allen
2010-02-06 05:25:48