Schema Compare for Oracle - 2.0
Setting up the synchronization - Schema Compare for Oracle
When you have reviewed the comparison results, you can select the objects you want to synchronize.
By default, no objects are selected for synchronization. You select objects to synchronize using the central check boxes in the results pane:
To select all the objects in a group for synchronization, select the check box on the grouping bar for that group; alternatively, you can right-click within the group and then click Include All Objects in this Group.
To exclude all the objects in a group from the synchronization, clear the check box on the grouping bar for that group; alternatively, you can right-click the group and then click Exclude All Objects in this Group.
If only some objects in a group are selected for synchronization, the check box on the grouping bar shows a mixed state:
To include or exclude all objects that are displayed in the results pane, use the top-level check box in the central column:
You can also filter the object types and use the Find box to assist you with your object selections.
Object selections are remembered when you save a project. Note that if you save a project with a grouping set to include all objects in that group, the next time you use the project all objects in that group are selected for synchronization, even if they did not exist when the project was saved.
When you have selected the objects you want to synchronize, click 
Synchronization Wizard to start the Synchronization wizard.
Example: Selecting only views
To select only views for synchronization:
- In the central column of the results, clear the top-level check box if it is selected.
- In the Filter pane, ensure that the All object types included check box is selected.
- From the Group by box, select Type of object.
The objects are now grouped by their object type.
- On the grouping bar for views, select the check box to include all of the objects in this group for synchronization.
Example: Selecting objects that exist only in the source
To select all objects that exist only in the source database for synchronization:
- In the central column of the results, clear the top-level check box if it is selected.
- In the Filter pane, ensure that the All object types included check box is selected.
- From the Group by box, select Type of difference if it is not already selected.
The objects are now grouped by whether they are different, identical, or present in only one of the data sources.
- On the grouping bar for objects that exist only in source database name, select the check box to include all of the objects in this group for synchronization.
Example: Selecting only tables that exist in both databases but are different
To select only tables that exist in both databases but are different for synchronization:
- In the central column of the results, clear the top-level check box if it is selected.
- In the Filter pane, clear the All object types included check box, and then select the Table check box.
Only tables are now displayed in the results.
- From the Group by box, select Type of difference if it is not already selected.
The objects are now grouped by whether they are different, identical, or present in only one of the data sources.
- On the grouping bar for objects that exist in both but are different, select the check box to include all of the tables in this group for synchronization.
See also |
Was this article helpful?
Using Schema Compare for OracleSchema Compare for Oracle
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
Schema Compare for Oracle
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
