Linking Static Data

Source Control is a Microsoft SQL Server Management Studio (SSMS) add-in that is designed to manage database changes in most well-known version control systems. With the help of the tool, you can version-control database schemas and data, roll back unwanted changes, handle static data conflicts, and maintain the integrity of the database.

Along with database schemas, dbForge Source Control for SQL Server allows linking and version-controlling static table data.

  1. In Object Explorer, right-click a database containing tables with static data.

  2. Point to Source Control, and then click Link/unlink static data… on the shortcut menu.

    Link Static Data

    The Source Control Link Static Data dialog box opens.

  3. Select the required tables containing static data and click Apply.

    Link Static Data dialog box

    Note
    You can link and source-control only the tables with the properly defined primary key.

    The Refresh dialog box will open automatically showing all stages of the refresh procedure.

    Refresh

  4. Once the refresh is complete, Source Control Manager opens. Navigate to the Local Changes section, and select the linked tables with static data, and click Commit.

    Link DB to Working Folder

    Note
    Source-controlling table data (including the Getting latest and Commit operations) may be a quite time-consuming operation. Thus, we highly recommend you to source-control static data only. During the commit of large static data tables with a large number of records may result in freezing and time out of dbForge Studio for SQL Server.