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.
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 might cause SQL Source Control to time out. If static data is slowing down performance, you can disable checks for changes to static data on the Setup tab under Options just for this database. |
To source-control data:
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. |
The data is committed to source control.