Page History
IDERA SQL Data Compare for Oracle Database displays the data synchronization script on a new window within the comparison session tab. The new window name includes the [server].[database] for which the script was generated.
| Info |
|---|
If the data synchronization script exceeds 32MB, IDERA SQL Data Compare displays only the first 32MB-size block of the script in order to preserve the memory. However, if you choose to execute the script, the entire script and not just the first block is executed. If you want to view the whole script, you can save it to a file, and then open the file using a text editor. |
...
- Refreshing the comparison and regenerating the script. While reviewing the script you may discover that you should have done something different during the preparation phase before running the compare. IDERA SQL Data Compare allows you to change the options at any point during the process and simply click Refresh Result on the ribbon to redo the comparison without having to go through the whole exercise of selecting columns and keys etc. Note however that this refresh action does not affect the synchronization script already generated. To refresh the script window, simply re-generate the script.
- Opening the script in SSMS. From the script window you can transfer the script directly to SQL Server Management Studio (SSMS) assuming you have SSMS installed on your machine. Simply right click anywhere on the script, and then click Launch SSMS or click Open in SSMS in the ribbon (under the Synchronize tab).
...
| Excerpt |
|---|
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > > |