<h1 id="linking-static-data"><a aria-hidden="true" class="anchor-heading icon-link" href="#linking-static-data"></a>Linking Static Data</h1>
<h2 id="linking-static-data-tables"><a aria-hidden="true" class="anchor-heading icon-link" href="#linking-static-data-tables"></a>Linking static data tables</h2>
<ol>
<li>Right click a database in <a href="/DevLog/notes/6qr9lzmzbkr3s4xwqxow04y">Ssms</a></li>
<li><code>Other SQL Source Control tasks</code></li>
<li><code>Link or unlink static data</code></li>
<li><code>save and close</code></li>
<li>Right click a database in <a href="/DevLog/notes/6qr9lzmzbkr3s4xwqxow04y">Ssms</a></li>
<li><code>Commit changes to source control</code></li>
<li>In source control pane you will now see a commit with the data link change type that shows the diff as a bunch of insert statements</li>
<li>Commit message and commit
<ul>
<li>Result is that in your source control repository there is now a <code>Data/</code> directory with a SQL file in it consisting of the insert statements.</li>
</ul>
</li>
</ol>
<ul>
<li><strong>To source control the data on your tables they need a PK</strong></li>
</ul>
<hr>
<strong>Backlinks</strong>
<ul>
<li><a href="/DevLog/notes/vt2uvnxhvp6t1y95vdepuq1">Implementation Notes (DevLog)</a></li>
</ul>

Linking Static Data


The hyperfixated rabbit hole diving knowledge base that is my brain looking at technology.
