Data Compare

The Data Compare tool offers features that let's users specify the primary key, selected and sorted columns, table query comparison, and let's users create delta scripts for table synchronization. The tool has a comprehensive GUI interface, giving users an easy process to have a graphical representation of the differences between their data.

Aqua Data Studio has a comprehensive Data Compare Tool with an easy to use Graphical User Interface (GUI). This GUI offers many ways to gather and view the differences. It allows the users to specify the primary key; selected and sorted columns; table to query comparison, and let's users create delta scripts for easy to use table synchronization.

Launch the Data Compare Dialog

Data Compare Dialog

Select the query or the table for the source and target connections, select the compare options and then use our existing results set compare engine to do the comparison.

• Connection - Shows the connected database.
• Table - Click on the three dots on the right side to select a table.

• Query - Once you made your connection, queries can be edited.
• Key Columns - Keys can be selected from the menu below.
• Selected Columns - All columns are selected by default, to unselect a column users can eliminate columns by clicking the three dots on the right side.
• Sort Columns - To arrange the data, before comparing Data.

Target: Database to be compared with

• Connection - Select the connection to be used to compare with the source.
• Table - Automatically selected table.

• Query - Once you made your connection, queries can be edited.
• Key Columns - Keys can be selected from the menu below.
• Selected Columns - All columns are selected by default, to unselect a column users can eliminate columns by clicking the three dots on the right side.
• Sort Columns - To arrange the data, before comparing Data.

Compare Options:

• Select specific options you want to apply in the comparison.

• Only show rows that are different - Rows that are the same will not show.
• Ignore Case -
• Max Rows - Select the maximum of rows per result.
• Generate HTML Report - Generate the report as HTML, letting you choose font and font size.
• Generate Excel Report - Generate the report as an Excel.
• Save Report to - Let's you chose the file where you want to save it.

Generate Delta Script:

• Select options if you want to sort Data in Delta form.

• None
• To make target table same as the source based on selected columns - Changes will be made based on the source, to make target table the same.
• To make source table same as the target based on selected columns - Changes will be made based on the target, to make source table the same.
• Save Script to - Select the file where you want to save the script.

Verify the information and click Compare.You will see an status window while the comparison is in process.

When users click Compare, it will generate a query based on the user's options and run against the source and target connection. Then, it will use existing results set/compare engines to complete the comparison.

Data Compare Results

The Data Compare Results window gives users precise information so they have immediate results.

 

 

 

The result sets you have selected in the Select Result Sets dialog are displayed together according to their state. This table describes the color code and results for each state. 

 

State	Description
	The records exist in result set 1 but not in result set 2.
	The records exist in both result sets but are different.
	The records exist in result set 2 but not in result set 1.
	The records in both result sets are equal.

• You can use the navigation toggle keys (, ) to navigate between different states and within the same state.
• When clicking a cell, view its content in the Preview Panel, also known as the Selected Cell Content area. Contents in the deleted state are displayed in the upper section. Contents in the added state are displayed in the lower section. Contents in the equal and changed states are displayed in both the upper and the lower sections. You can show or hide the Preview Panel by clicking on the toolbar.
• You can see the executed query details in the Results Compare for header. You can show/hide this header by clicking  on the toolbar. You can also see the total of fetched records and the total time taken to fetch these records right below the Grid tab. You can show/hide this information by right-clicking anywhere in the grid, and then selecting Show/Hide Toolbar.
• Results Compare also supports repositioning of columns and multicolumn sorting with ascending and descending. For example, to sort "keyspace_name" in ascending order and "Ranges" in descending order, click the "keyspace_name" header and press Ctrl, then double-click "Ranges" header. The icon appearing on the headers are a sign of successful sorting.

• You can filter comparison result using primary keys or filtering, perform a search operation, and change the display of the grid result using . You can assign new colors to states from the Options dialog. Users can refresh the comparison result or perform a new compare.
• Quick filters offer the advantage of filtering the records displayed in the grid view, based on the user-specific value. By using the Search box, you can define a scope to search for text and numbers, perform a case sensitive or case insensitive search, and search by using wildcards and regular expressions to match found options.

• By right-clicking the Data Compare table, users get different options to View or Copy.

Right-Click Action	Description
Select All (CTRL/Command+A)	Selects all records in the grid view.
Results Compare (CTRL/Command+Shift+K)	Opens the Select Results Sets dialog.
Copy (CTRL/Command+C)	Copies the selected records in the grid view.
Copy...	Shows additional options when you point to this option.
Copy As...	Opens the Copy to Clipboard dialog.
Paste to Window	This option is disabled and not applicable to Results Compare.
View As Text	Displays the selected record in the View dialog.
Show/Hide Toolbar	Shows/Hides the toolbar in the grid view.

• Selecting Copy..., users can select additional options.

• Copy As, opens the Copy to Clipboard dialog, giving different options