VS for Database Developers: Search Tables

How do you handle the contents of lookup tables, which should be considered “code,” not data?

+3
source share
1 answer

There is currently no good support in VS for database developers for managing link data.

There is a good posting on MSDN that suggests using this missing feature, which uses a temporary table and a post-deployment script to merge changes into reference data during deployment.

Essentially, your referenced data exists as a static set of insert statements in your temporary table, and then the merge keeps the current tables up to date.

I have used this approach in a large CI full project for the last five months or so and found that it works well.

I also crossed my fingers that they would add better support for this in VSDB vNext.

+4
source

Source: https://habr.com/ru/post/1731632/


All Articles