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
How to create DACPAC file?
In this post, I will explain what the DACPAC is and how to create it. In the previous post in DevOps series, I described how to create a new, empty
ADF and passwords with Azure Key Vault & set up GIT
Have you worked with ADF yet? Did you configure the GIT code repository to automatically upload all changes to having your own isolated branch during development? If not yet, in
){kind=link}
ASF 015 video invitation
“This was in Dallas, we had our MVP Summit in Dallas and there were only maybe like less than 10 SQL Server MVPs.” Do you want to know who has
0 Comments
No Comments Yet!
You can be first to comment this post!