Working DB Object Comparison

The Comparison of data stored within two databases of the client database system will provide opportunity to copy into the target the object dependancies required to build the object again. Once the CREATE COMPARISON  button has been clicked, the system will provide a new page of comparison data.

Each object will show a Comparison status of Red, Yellow, or Green with an option to promote that object to the Target Working database.

RED - this status indicates that the Source data is NOT present within the Target datasource - the data will be copied into the target datasource if the Promote toggle is set to active.

YELLOW - this status indicates that the Source data is present within the Target datasource but not exactly the same scripting - in this case the target data will be over written by the source.

GREEN - this status indicates that the Source data is present within the Target datasource with the exact same scripting - the Promote toggle will be hidden for these rows.

At this point, the user will review the differences and determine which data should be promoted to the target datasource. The Promote toggle is used to activate each row.

Note

The Auto Select Dependencies toggle is set to Active by default, so that if you promote a table or view that has dependencies, those dependencies will be automatically promoted. If the toggle is set to Inactive, dependencies will remain in the list but will not be promoted.

Either select each row individually, or click SELECT ALL VISIBLE button to active the promotion of these items.

The SQL Server database for each of these datasources contain part of their own sets of data.

Once the items are selected for Promote, a count of selected items displays within the panel for Selected Objects for Promotion.

Click START PROMOTION button to initiate a copy from source to target datasources where similar but not exact data is over written. A message provides percentage completion status.

This job runs quickly although it may take some time to actually build out all of the Tables and Views set to promote. The resulting page displays the outcome of the process. Items marked with Green status in the Comparison are the ones that match exactly from source datasource to target datasource.

Items that promoted from source datasource to target datasource successfully will show as a Check Mark  within the Promotion Success column.

Items that failed to promote will show a Check Mark   in the Promotion Failed column. In this case, all of the selected objects were promoted successfully from the source to the target database.

A check of the SQL Server databases will show that the promotion was successful.

Note

At this time there is not a history of promotion actions. So, once the user exits this page, the process is complete.

Issues with Promotion

Should an Table or View fail to promote during the process, the user may adjust the source datasource and then within this page click on the Refresh  button to attempt to complete the copy.

If the user attempts to promote a view, and the new view definition fails for some reason. the view is returned to it's original state.