Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedImage RemovedAfter reviewing the schema compare results, select objects for synchronization, then click and complete the synchronization process in the following order.

...

The Review Dependencies tab shows objects selected for deployment and the dependent objects. The dependent objects are synchronized to prevent the deployment script from failing. Objects are displayed in the Affected Objects column because these objects are referred by or refer to the objects in the Referencing Or Referenced By column. When you click a dependent object, you can view the differences between both the source and target objects in the default viewer.
 If a dependent object supported in Aqua Data Studio is not supported in Schema Compare, then during deployment, Schema Synchronization will not include dependencies of this dependent object, and the deployment script will fail. To synchronize these dependencies, create the dependent object on the target server before executing the deployment script.
Image Modified 
 
From the Dependent Objects area, you can include/exclude dependent objects for synchronization. However, you cannot unselect the dependent objects that are also present in the Objects Selected For Deployment area.
 We recommend deploying all dependent objects, to avoid deployment script from failing or receiving unexpected results.

 
You can use Search to narrow down the result. You can also copy the list of dependent objects to a different editor.

...

Schema Synchronization will display various options that you can include or exclude from the deployment script.
Image RemovedImage Added

Statement Separator (All Servers)

...

This section contains information on the server-specific options.

MS SQL Server

Image RemovedImage Added

Include Print Comments 

When you select this check box, you will see a print comment for every action that Schema Synchronization will perform in the deployment script. After the deployment script is executed, you can see the comment of each action in a print command with its execution status in the Text Results Tab.
Image RemovedImage Added

Refresh views 

...

The definition of the target view will be refreshed based on the updated target object as Schema Synchronization will add the “sp_refreshview” procedure in the deployment script. This procedure will update the definition of the target view. So, in the following example, after the script is executed, c3 and c4 columns are dropped from the target table, and the view is refreshed.

Image RemovedImage Added

 Check box unselected

The definition of the target view does not change based on the changes made to the target table and therefore the view definition will become invalid. So, in the following example, after the script is executed, c3 and c4 columns are dropped from the target table, but the view is not refreshed.

Image RemovedImage Added

Use a Single Transaction 

When you select this check box, Schema Synchronization inserts transaction statements in the deployment script. If the deployment script fails, these transaction statements allow the target server to roll back to its initial stage by reverting all modifications made from the start of the execution of the deployment script. If a single statement in the deployment script fails, the complete transaction will fail. 
Image RemovedImage Added

Sybase ASE Server

Image RemovedImage Added

Generate setuser 

...

Schema Synchronization will display warnings encountered while creating the deployment script. The warnings are categorized as HighMedium, and Low. You can also view the changes that Schema Synchronization will make in the script under the Summary and Detail column. You can hover the mouse on any warning in the Detail column and view the entire warning description in a tooltip. For additional information on warnings, see Schema Synchronization Warnings. Besides this, you can perform various other actions, such as searching warnings by using various search options or copying warnings to a different editor.
Image RemovedImage Added

Summary Tab

You see actions and modifications that Schema Synchronization will perform on the objects of the target schema. You can view these actions in different groups by selecting an option from the View by drop-down list.

...

Other actions you can perform in this tab are searching summary actions by using various search options and copying summary actions to a different editor.
Image RemovedImage Added

Deployment Script Tab

In the Deployment Script tab, you see the generated SQL script to synchronize the source and target schemas. The comments above each SQL statement are the modifications that Schema Synchronization will perform on the objects of the target schema. There are various actions you can perform in this tab, such as saving the script in the .sql format on your local system, searching for DDL statements within the script, copying the script to a different editor, and collapsing the code to a single line using toggles. After you have reviewed the script, click Open Script in Query Analyzer, and then click Image Removedclick Image Added, to execute the deployment script on the target schema.
We recommend backing up the target database and executing the script in the test environment before executing it in the production environment.
Image RemovedImage Added
 When you execute the deployment script, Schema Synchronization drops that column from the target table.

...