SSDT: Scripting static data from SQL Server (video)

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

Previous ADF - Deployment from master branch code (JSON files)
Next ASF 031: Paul Andrew interview

About author

Kamil Nowinski
Kamil Nowinski 194 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Video 1Comments

ASF 021 video invitation (Star Wars Theme)

Since now, we will not keep our guests in secret. We want you to be prepared and wait if you’re interested in. First time 2 vs 2 in #AskSQLFamily podcast.

DevOps 14 Comments

ADF – Deployment from master branch code (JSON files)

In the previous episode, I showed how to deploy Azure Data Factory in a way recommended by Microsoft, which is deployment from adf_publish branch from ARM template. However, there is

Automate deployment of Azure services with ARM Template (video)

Automation is a useful thing. It allows to avoid many mistakes and saves a lot of time. However, you need to invest some time to get started. At least the

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply