Everyone who works with Oracle databases has to synchronize them from time to time. dbForge Studio for Oracle provides functionality that lets you visually see the differences and set up a safe and accurate database schema synchronization process without data loss.
Before synchronizing schemas, you should first compare them. For this, you can use the schema comparison functionality provided in dbForge Studio for Oracle. The New Schema Comparison wizard enables you to compare databases, snapshots, or versioned snapshots. A rich set of comparison options and an object filter make the comparison process highly customizable.
After the comparison is completed, a neat grid with comparison results will be presented to you. You can manage the results as required: filter, group, view differences between objects, exclude objects from synchronization, etc. You can also save the comparison settings for future use and generate comparison reports.
Now, you can proceed to schema synchronization. Click the Synchronize... button to open the Schema Synchronization Wizard, where you can set options, select dependencies, view synchronization issues and the summary. The wizard prompts you to select one of the three output options to manage synchronization scripts.
If you choose Open the synchronization script in the internal editor, the generated synchronization script will be opened in SQL Editor. You can review the script, make changes, and execute the script to finish synchronization.
First, you should compare the data contained at the source and the target. The Data Comparison wizard allows you to quickly compare chosen sets of data and fine-tune the comparison process - it provides various comparison Options (for example, comparing views in addition to tables) and the ability to customize Mapping.
When the comparison process is finished, a Data Comparison document will be presented. Here, you can filter and sort the resulting information, perform full-text search in data differences, hide unmodified columns to simplify further analysis and generally manage the results in dfferent ways. A comparison report containing actual data can be generated either in Excel or HTML format.
Now, you can use the Data Synchronization wizard. You can manually specify which tables and even which records to synchronize. You can view any synchronization warnings and other information at the Summary page.
The Data Synchronization wizard also allows you to create an update script for the target database and save it to a file - you can view the script structure and edit it at the Action Plan tab.
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.
