Data Compare Script
Displays the sync script based on the data compare results and selected tables ready for execution.
The script is read-only.
When the data script is executed it is performed in batches and SQL Delta loads a group in like items such as an Insert and then sends the batch to the database server when a specific limit is reached.
Actions
Execute - runs the script on the database server (F6).
Print - sends the script to the selected printer.
Show - Open Windows Explorer and locates the script.
Copy - Sends the script to clipboard. Warning large scripts may fail if sent to the clipboard
Auto Refresh - When closing the script tab and the script was executed, automatically refresh the compare.
Notes - Show a list of actions to occur. Eg. dbo.Address - 100 rows to insert, etc.
Auto Delete - When closing the script tab automatically delete the script from file.
Script Display
The data script is not editable however can be searched and reviewed.
Script Editor Actions
Copy, Select All |
The same as most read-only editors, text can be selected and copied. |
Show Special Chars |
Display paragraph marks, tabs, spaces and other control characters that are normally invisible. |
Increase, Decrease, Reset Text Size |
The size of the text can be changed to make larger, smaller or reset to the default. |
Toggle Bookmark |
Create a bookmark at a specific point in the script. Up to 10 bookmarks can be created. Repeating the Toggle Bookmark process on an existing bookmark removes the bookmark. Ctrl+Shift+Number is the shortcut. |
Goto Bookmark |
Move the cursor to the bookmark, if it exists. Ctrl+Number is the shortcut. |
Executing the Script
Once the execute script begins a message box is shown describing each action as its sent to the database server. If comments are turned off in Options then a minimal level of feedback will be displayed.
Generally each script item should return a success message indicated by the tick icon however from time to time a script error may occur. Errors come from check constraints or other constraints where the data does not meet the specific column requirements. While errors are not desirable if they do occur and you have transactions active (again see Options) then the changes for that object will be rolled back.
Only Errors - This button filters the messages to display only the errors returned by the database server. By double clicking the error row the script window is changed to display the SQL code that generated the error.
Search Text searches through the messages.
Use the menu to Select, Copy and Save the messages to file.