ApexSQL Pump 2020 – Screen shot tour

ApexSQL Pump is a tool capable to import data and export to different data source files. The application is a standalone with possibility to be run via the CLI. Various import and export files are used such as CSV, SQL database, MS Excel, MS Word and much more.

Installation

The installer can be downloaded from our download page and running the installer will open the Welcome screen:

Welcome screen in the ApexSQL Pump installation wizard

Going on the Next button it will show the STA (Software Transaction Agreement) which has to be accepted in order to proceed further with the installation:

Software Transaction Agreement in the ApexSQL Pump installation wizard

When the terms are accepted the installation process will start:

Installation process in the ApexSQL Pump installation wizard

On the last step when the installation is finished, if the Run option is checked, as is set by default, the tool will start right after a click on the Close button:

Finished installation of ApexSQL Pump

Visual themes

The ApexSQL Pump application offers to users, like every ApexSQL product, three themes for using the tool.

The first one is the Dark theme, which is set by default, and shown during the installation process:

ApexSQL Pump dark theme

The second one is the Blue theme shown below:

ApexSQL Pump blue theme

The third theme used in ApexSQL Pump is the Light theme:

ApexSQL Pump light theme

Startup screen/Create new project window

By default, the New project window is shown where the data must be set before going further:

New project window in ApexSQL Pump

On the second step in the New project window, which is the Action tab, there are two possibilities, Export or Import the data within the tool from different sources:

 Action tab in ApexSQL Pump

After the data is loaded, the main grid is shown with the results from the exported or imported data (in this case Export action is used):

Export main grid in ApexSQL Pump

Manage export window

Under the Manage export window there are three tabs: Formats, Rows and Additional scripts.

As shown on the picture below, there are 13 different export formats that can be used:

Manage export window in ApexSQL Pump

Export process results window

Before the export process is finished, it can be seen under the Job summary what will be exported after the process is done:

Export job summary in ApexSQL Pump

Manage import window

When the connection to the SQL Server is set and the Import action is used under the Manage import window, there are two tabs: Format and Additional scripts.

In the Format tab is shown that it’s possible to add different input sources at the same time:

Manage import window in ApexSQL Pump

It can be decided from which file or database import data will be inserted, as well it can be set position and import by rows or columns from the right side of the Manage import window.

When the Import action is used in the main grid data results are shown below:

Import main grid in ApexSQL Pump

Import process result window

After everything is checked and mapped in the Import main grid, click the Process button under the Home tab the results are shown before process is finished to check if everything is set as desired:

Import job summary in ApexSQL Pump

To see the version of the standalone application, switch to the Resources tab and click the About button:

About window in ApexSQL Pump

 

March 31, 2020