These pages cover SQL Source Control 3. Documentation for older versions is also available.

Skip to end of metadata
Go to start of metadata

To source-control data in SQL Source Control, you first link it to source control, then commit it. Linking associates a table's data with source control so subsequent data changes are detected and static data can be shared across the team.

Linking to static data affects performance


Committing and getting the latest version of data can be slow. We recommend you only source-control static data (also known as lookup or reference data). Source-controlling very large static data tables may cause SQL Source Control to time out.

If static data is slowing down performance, you can disable checks on changes to static data.

To source-control data:

  1. In the Object Explorer, right-click the database or table with data you want to source control.
  2. Select Other SQL Source Control Tasks, then click Link/Unlink Static Data.
  3. The Link/Unlink Static Data dialog box opens:

    The dialog box shows a list of the tables in the database.

    You can only source-control data in tables with a valid primary key. The primary key is used as the comparison key to identify corresponding rows.
  4. Select the tables you want to link and click Save and close.
    SQL Source Control creates a file for the table's data, but the data itself hasn't been committed yet.
  5. On the Commit Changes tab, make sure all Data Link changes are selected, type a comment (optional), and click Commit.

    The data is committed to source control.

  • No labels