Add a Perforce repository
Last modified: March 28, 2025
Schema Compare allows you to establish the connection to a Perforce repository when the source control is selected as source or as target.
To add a Perforce 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, choose Perforce (P4) as a source control system from the Source control system list and do the following:
- Specify P4PORT, User name, and Password for the Perforce server.
- In the Workspace field, create a new workspace or select an existing one from the list.
- By default, the repository name will be automatically set after specifying the workspace.
Note
It is important to ensure that the Source Control feature of dbForge Schema Compare uses its workspace for each database link.
It is not recommended to use this workspace from other applications.
To get proper settings for P4PORT, Username, Password and Depot, contact your system administrator.
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. Optional: Click Test to verify that the database can be successfully connected to source control.
6. Click OK to apply the changes and close the Source Control Repository Properties dialog.
To add a Perforce 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, choose Perforce (P4) as a source control system from the Source control system list and do the following:
- Specify P4PORT, User name, and Password for the Perforce server.
- In the Workspace field, create a new workspace or select an existing one from the list.
- By default, the repository name will be automatically set after specifying the workspace.
Note
It is important to ensure that the Source Control feature of dbForge Schema Compare uses its workspace for each database link.
It is not recommended to use this workspace from other applications.
To get proper settings for P4PORT, Username, Password and Depot, contact your system administrator.
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. Optional: Click Test to verify that the database can be successfully connected to source control.
6. Click OK to apply the changes and close the Source Control Repository Properties dialog.
To create a new workspace
- Under the Workspace section of the Source control settings dialog, click New.
- In the New Workspace dialog, specify a name of the new workspace, an existing Depot, and a path to the Folder with database scripts. Click … Browse to select an existing folder or create a new one.
Note
dbForge Schema Compare will work with scripts from this folder only. If you leave the Folder field empty, it will be considered that the whole depot contains database scripts. In this case, database scripts will be located in one of the Devart folders.
To select an existing workspace
- Select an existing workspace from the list. Workspace also specifies the local folder where dbForge Schema Compare will store database scripts.
- Optional: Select Mapping from the list. The mapping specifies the depot and the remote folder to be used by dbForge Schema Compare.
Note
Usage of existing workspace is not recommended due to possible conflicts with other applications or links.
For the correct work of the Source Control feature of dbForge Schema Compare, you and your colleagues must use identical settings for P4PORT, Depot, and Folder when configuring a new Workspace.
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.