In dbForge Schema Compare, you can compare two data sources: database schemas, snapshots, and versioned snapshots. The databases can be located on different servers. After you select data sources, you can customize the comparison process by specifying additional schema comparison options to suit your requirements.
After the comparison is complete, the Schema Comparison document opens with two main sections:
1. Open the New Schema Comparison wizard by using one of the following options:
2. On the Source and Target page of the wizard that opens, select the source and target type: a database, a snapshot, or a versioned snapshot.
Note
The details required will vary based on the selected type.
3. Under Schema Mapping, select the checkbox next to the schema you want to compare.
4. Optional: On the Options page, select the options to tailor the comparison process to your needs.
5. To run the schema comparison, select Compare.
When you select Database from the Type list, perform the following steps:
1. In the Connection box, select an Oracle server connection on which a database is located.
Note
If you want to add a new connection or edit the existing one, do the following:
- In the Connection box, select Manage.
- In the Connection Manager that opens, select Add to create a new connection or Edit to modify the existing one.
- To save the changes, select OK.
2. Under Schema Mapping, select the checkbox next to the schema you want to compare.
When you select Snapshot from the Type list, perform the following steps:
1. In the Snapshot box, do either of the following options:
2. Under Schema Mapping, select the checkbox next to the schema you want to compare.
Note
The Versioned Snapshot functionality is now available only for TFS and SVN. If you select any other version control system, the Snapshot box will display a notification - ‘Specified Version Control System is not supported’.
When you select Versioned Snapshot from the Type list, perform the following steps:
1. In the Repository box, do either of the following options:
Note
If you want to create a new repository or edit an existing one, do the following:
- In the Repository box, select Manage.
- In the Repository Manager that opens, select New to create a new repository, Edit to modify an existing one, or Delete to remove the selected repository.
- To save the changes, select OK.
2. In the Snapshot box, select a snapshot you want to compare.
3. In the Revision box, select a revision you want to compare. The latest (head) revision is selected by default.