Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
To launch the Schema Synchronization Tool from the Aqua Data Studio menu bar
To launch the Schema Synchronization Tool from the Aqua Data Studio Servers pane
The servers you compare are known as the source and the target. The schema synchronization tool allows synchronizing the objects specified in the schemas. When schemas are synchronized, the target is updated, and the source is left unchanged.
You can compare and synchronize all schemas by selecting <All Schemas> option from the source and target drop-down lists. However, Sybase ASE Server does not allow synchronization of all schemas.
You can select all objects or specific objects for schema compare and synchronization. Different databases have different schema objects.
When you select a schema object, all objects of that type are listed in the Objects area. These objects are by default selected for compare. The objects in the left pane are the source schema and on the right are the target schema. You can filter objects using the Search text box. You can also use different toolbar actions to select or clear objects from schema compare and synchronization. This table lists these actions.
|To check all selected schema objects.|
|To clear the selected schema objects.|
|To invert the last selection.|
You can also select objects by using these right-click actions.
|Check Selected||Checks all selected schema objects.|
|Uncheck Selected||Clears the selected schema objects.|
|Reverse Selected||Inverts the last selection.|
|Show All (Clear Filter)||
Displays all objects by removing the search filter applied to the objects.
This action applies to Objects area.
|Check All||Selects all schema objects.|
|Uncheck All||Clears all selected schema objects.|
|Select All||Highlights all the listed schemas and its object names.|
|Invert Selection||Inverts the list of selected schema objects.|
This option functions differently for both the schema compare and schema synchronization tools. The following table explains this difference.
|Schema Synchronization Tool||Schema Compare Tool|
In the schema synchronization tool, this option is selected and read-only. During schema compare, it extracts dependencies of the selected schema objects. These dependent objects from the selected source and target objects can be viewed in the default viewer of the Review Dependencies tab.
In the schema compare tool, this check box is always unselected and in the read-only mode.
Includes permissions granted on each object while generating the script.
Includes indexes and triggers applied to the tables of the source and target schemas.
For schema synchronization, we recommend that you unselect this option and then from the Schema Objects area, select Indexes and Triggers. Selecting these check boxes also enables schema synchronization to include the DDL of trigger or index created on View or Materialized View in the deployment script.
Includes table constraints in the script.
Includes names of all constraints such as; primary key, foreign key, unique, and check constraints in comparison script.
Includes storage properties applied on tables/constraints/indexes of the source and target schemas in the script.
Includes comments defined on a table and columns in the script.
Sorts columns in both the source and target tables in alphabetical order.
When you choose this option, the comparison engine performs a case insensitive comparison between the source and target scripts and does not distinguish between upper and lower case letters.
When you choose this option, the comparison engine trims the trailing and leading whitespaces in both the source and target scripts.
When you choose this option, the comparison engine trims the trailing and leading whitespaces in both the source and target scripts and performs a case insensitive comparison between both the scripts.
When you choose this option, the comparison engine ignores all whitespaces between the source and target scripts.
When you choose this option, the comparison engine performs a case-insensitive comparison and ignores occurrence of whitespaces between the source and target scripts.
When you choose this option, the comparison engine ignores all whitespaces and empty lines between the source and target scripts.
When you choose this option, the comparison engine performs a case-insensitive comparison and ignores occurrence of whitespaces and empty lines between the source and target scripts.
For example, if you have objects named AquaTable and aquatable in the source and target schemas and you select this check box, then the comparison engine considers both these objects as equal. If you do not select this check box, then comparison engine considers both these objects as different.
Schema Synchronization uses the quote identifier set in Script Options for schema object names when it generates the deployment script.
To choose a quote identifier, on the Aqua Data Studio menu bar > File > Options > Scripts > <Database_Name> > Quote Identifier.
|Script Ignore Policies||