ApexSQL Data Diff for MySQL 2020 – Screen shot tour

Welcome to the ApexSQL Data Diff for MySQL screen shot tour. The ApexSQL Data Diff for MySQL is a standalone application for comparison and synchronization data between two live MySQL databases. The first step is to start the installation file, where the Welcome screen will be shown:

ApexSQL Data Diff for MySQL Welcome screen

Click on the Next button guides us to the next step, which is to accept the Software Transaction Agreement:

Quest Software Transaction Agreement step

When the Software Transaction Agreement is accepted, the next step is to choose the location for installing ApexSQL Data Diff for MySQL. By the default, the installation will be performed on the partition where the Windows operative system is installed:

ApexSQL Data Diff for MySQL browsing location for the installation

On the next screen, it will be shown the progress bar of the installation process of ApexSQL Data Diff for MySQL:

ApexSQL Data Diff for MySQL progress bar of the installation

When the installation is successfully finished on the left bottom side release notes link can be clicked and seen on the website, and since the checkbox Run ApexSQL Data Diff for MySQL is checked, the tool can be started right away after the Close button is clicked:

ApexSQL Data Diff for MySQL successfully installed

When the application is started, the first thing that shows by default is the Project management window where recently saved projects can be directly loaded:

ApexSQL Data Diff for MySQL Project management window upon starting

When the button New is used from the Project management window, the New project window is shown including the tab where Data source can be set:

ApexSQL Data Diff for MySQL New project window with Data sources tab

The next tab is the Options tab, where different object types, comparison data, and synchronization data options can be defined:

ApexSQL Data Diff for MySQL Options tab in the New project window

After that, comes the Advanced options which first include the Object mapping tab where the mapping between objects can be customized, objects can be mapped or unmapped, and the last is the Object filter tab where specific objects can be selected before the comparison:

ApexSQL Data Diff for MySQL Object mapping tab under the Advanced options

ApexSQL Data Diff for MySQL Object filter tab under the Advanced options

The main window of the application is divided into three tabs with different options in them. The tabs are Home, View, and Resources:

ApexSQL Data Diff for MySQL Home tab

ApexSQL Data Diff for MySQL View tab

ApexSQL Data Diff for MySQL Resources tab

The middle section of the application shows the Results grid where objects are compared:

ApexSQL Data Diff for MySQL compared objects in the main grid

On the bottom by the default is shown Data difference view panel, where can be seen more details for compared objects:

ApexSQL Data Diff for MySQL Data difference view panel in the main grid

The different types of Export comparison results that users can use can be found under the Home tab:

ApexSQL Data Diff for MySQL different type of the export results

Additional options can be used when the Options button is used under the Home tab in the main window. The Options window is divided into two tabs, General tab, and Output tab. The tab General is the first shown with different settings in it:

ApexSQL Data Diff for MySQL Options window with General tab settings

The second tab shown in the Options window is the Output tab with also various settings in it:

ApexSQL Data Diff for MySQL Options window with Output tab settings

When the Synchronize button is clicked from the Home tab, it will open the Synchronization wizard window, which includes three steps before the synchronization is started. The first step is the Synchronization directions:

ApexSQL Data Diff for MySQL first step in the Synchronization wizard

The second step in the Synchronization wizard window is the Output options:

ApexSQL Data Diff for MySQL with second Output options step in the Synchronization wizard window

The third and the last step in the Synchronization wizard is the Summary and warnings step:

ApexSQL Data Diff for MySQL Summary and warnings the last step in the Synchronization wizard window

The automation script can be run from the Save as automation script button under the Home tab or in the Synchronization wizard from the bottom left side of the window by clicking the Automation script button. In the Automation script window are different options that can be defined before using the automation system for comparison and synchronization:

ApexSQL Data Diff for MySQL Automation script window with different options before the automation is set

To check the expiration date of the license for the ApexSQL Data Diff for MySQL, click the About button from the Resources tab:

ApexSQL Data Diff for MySQL About window from the Resources tab

To check if the latest major or latest patch version is used, click the Get updates button from the Resources tab:

ApexSQL Data Diff for MySQL using Get updates button from the Resources tab to check the latest version

 

August 27, 2020