SSDT: Scripting static data from SQL Server (video)
Out of the box, SSDT covers objects on a database level, like tables, stored procedures, views, functions, etc. That means schema only. In many cases, there is a need to INSERT initial data to a particular table(s). Very often they are called: master data, reference data, lookup data, static data or dictionary. Even though SSDT does not support data – you can take advantage of the post-deployment script and INSERT needed data in there.
How to do it many times, how to care of existing data in the target database, when and how to update the data and, finally, how to script those tables from an existing system and easily implement it within SSDT project?
I will explain in this video.
Links
Free app: Data Script Writer
About author
You might also like
New DB project with SSDT and import existing database
With this episode I would like to commence long-awaited new series It’s about DevOps with databases. I’ll start with SSDT, but not exclude other tools (like Redgate ReadyRoll) in the
Tokenization of database project in SSDT
SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens, especially when talking in a deployment/CI/CD/DevOps context. Variables can be found for
){kind=link}
ASF 020 video invitation
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer. Do you know which conference was inspired by the SQLBits
0 Comments
No Comments Yet!
You can be first to comment this post!