Add a TFVC repository
Last modified: March 28, 2025
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 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.
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.
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 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.
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.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by Schema Compare for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.