Add a TFVC repository

Schema Compare allows you to establish the connection to a TFVC repository when the source control is selected as source or as target.

To add a TFVC repository as source

1. In the upper-right corner of the Start Page or on the toolbar, click New Schema Comparison to open the New Schema Comparison wizard.

2. On the Source and Target page of the wizard, select Source Control as a source type.

3. In the Repository menu, click + New to open the Source Control Repository Properties dialog.

4. In the Source Control Repository Properties dialog, select Team Foundation Version Control (TFVC) as a source control system from the Source control system list and do the following:

  • Specify Server URL.
  • Choose Authentication type.
  • Depending on the selected Authentication type, specify:
    • Username and Password for Azure DevOps Server (formerly TFS) Base. Remember to enable the appropriate option in either cloud or server.
    • Personal access Token for Azure DevOps Server (formerly TFS) Token. Note that you need to obtain an authorization token in the security settings of your server.
    • Windows login for Azure DevOps Server (formerly TFS) Windows. If you select this type, your current Windows user account will be used.
    • Username and Password for Azure DevOps (formerly VSTS) Base
    • Personal access Token for Azure DevOps (formerly VSTS) Token
    • For Azure DevOps (formerly VSTS) Web, click Clear web authentication cache, and then click in the Database folder field to enter Username and Password for your web account.
  • Specify the Database folder. To do this, click Browse Browse to choose the folder where a SQL script will be stored.
  • Optional: The Repository name is automatically derived from the server URL. However, you can specify a different name of the repository.

Add TFVC Repository

Note

Contact your system administrator to get proper settings for the server URL, username, and password.

Note

If you are using TFS/Azure DevOps Server/ Azure DevOps Services with Git-based version control, you cannot use the Team Foundation Version Control (TFVC) mode to link. Use the Git mode instead.

For more information on creating a TFVC repository in Azure DevOps and linking it to source control, refer to Creating a TFVC Repository in Azure DevOps and Linking It to Source Control.

Optional: Click Test to check the connection. The pop-up window notifying you that the connection has been successfully established appears. Click OK to close the window.

5. Click OK to close the Source Control Repository Properties dialog.

TFVC Repository

To add a TFVC repository as target

1. In the upper-right corner of the Start Page or on the toolbar, click New Schema Comparison to open the New Schema Comparison wizard.

2. On the Source and Target page of the wizard, select Source Control as a target type.

3. In the Repository menu, click + New to open the Source Control Repository Properties dialog.

4. In the Source Control Repository Properties dialog, select Team Foundation Version Control (TFVC) as a source control system from the Source control system list and do the following:

  • Specify Server URL.
  • Choose Authentication type.
  • Depending on the selected Authentication type, specify:
    • Username and Password for Azure DevOps Server (formerly TFS) Base. Remember to enable the appropriate option in either cloud or server.
    • Personal access Token for Azure DevOps Server (formerly TFS) Token. Note that you need to obtain an authorization token in the security settings of your server.
    • Windows login for Azure DevOps Server (formerly TFS) Windows. If you select this type, your current Windows user account will be used.
    • Username and Password for Azure DevOps (formerly VSTS) Base
    • Personal access Token for Azure DevOps (formerly VSTS) Token
    • For Azure DevOps (formerly VSTS) Web, click Clear web authentication cache, and then click in the Database folder field to enter Username and Password for your web account.
  • Specify the Database folder. To do this, click Browse Browse to choose the folder where a SQL script will be stored.
  • Optional: The Repository name is automatically derived from the server URL. However, you can specify a different name of the repository.

Add TFVC Repository

Note

Contact your system administrator to get proper settings for the server URL, username, and password.

Note

If you are using TFS/Azure DevOps Server/ Azure DevOps Services with Git-based version control, you cannot use the Team Foundation Version Control (TFVC) mode to link. Use the Git mode instead.

For more information on creating a TFVC repository in Azure DevOps and linking it to source control, refer to Creating a TFVC Repository in Azure DevOps and Linking It to Source Control.

Optional: Click Test to check the connection. The pop-up window notifying you that the connection has been successfully established appears. Click OK to close the window.

5. Click OK to close the Source Control Repository Properties dialog.

TFVC Repository

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Schema Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.
Ready to start using dbForge Schema Compare for SQL Server?