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

SQL Source Control includes an optional beta version of the improved migration script feature. We'd love to hear what you think.

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.

Icon
  • 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.

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 is displayed:

    The dialog box shows a list of the tables in the database. You can select the ones you want to link to source control.

    Icon
    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.
    A file for the table's data has now been created, but the data itself has not yet been committed. To commit the data, commit the resulting Data Link change on the Commit Changes tab.
  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