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
Set up connection from Azure Data Factory to Databricks
Both, Azure Data Factory and Azure Databricks offer transformations at scale when it comes to ELT processing. On top of that, ADF allows you to orchestrate the whole solution in
17 months of podcasting – recap
Before I publish the next episode of “Ask SQL Family” podcast, I would like to stop and look back for a while. Any time is good for that kind of summarize,
){kind=link}
ASF 019 video invitation
Check how many bicycles he has got at home and where was the destination of last year of a 400 km trip? Which tool among Azure is the closest to
0 Comments
No Comments Yet!
You can be first to comment this post!