Linking a Database to SVN

dbForge 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. The Source Control tool enables you to link your database to Apache Subversion (SVN), which is an open-source software versioning and revision control system that strives to become a mostly compatible successor to Concurrent Versions System (CVS).

This topic explains how to link a database to Subversion (SVN).

  1. In Object Explorer, right-click a database you want to link to source control.
  2. Point to Source Control, and then click Link database to Source Control… on the shortcut menu.

    Link DB to Source Control

    The Link Database To Source Control wizard opens.

  3. On the Link tab of the wizard, click ‘+’ in the Source control repository field.

    Link DB Wizard

    The Source Control Repository Properties dialog box opens.

  4. Select Subversion (SVN) from the Source Control system drop-down list box.

    Link DB to SVN

  5. In Source control settings, specify:
    • Server URL, Username and Password for the SVN server.

      Note

      To get proper settings for Server URL, Username and Password, contact your system administrator.

    • Repository name.
  6. Click OK to close the Source Control Repository Properties dialog box.
  7. Select a database development model. For more information, refer to the Dedicated model and Shared model topics.
  8. Click Link. If a database is linked to source control successfully, a database icon in Object Explorer will be changed to show that a database is linked.

    Linked DB

After linking to SVN

If you are the first person to link this database, add the database objects to source control in an ‘initial commit’. To do this, go to the Local changes group, select the objects and click Commit. For more details, see Committing changes.

If you linked a database that is already in source control, update your database to the latest version. To do this, go to the Remote changes group, select the objects and click Get Latest. For more details, see Getting latest version.