Hello, and welcome to the ApexSQL Pump general overview video. ApexSQL Pump is a standalone application with the possibility to be run via CLI. The application is a SQL development tool capable to export and import files from different sources and file formats. It's a very easy wizard application, where the user will be guided through. ApexSQL Pump is able to import 13, and export up to 16, different source data and file formats.
Beside the import and export features, the application has some additional ones, which are pre and post-scripts when importing or exporting data, view full import and export process summary, export data from multiple tables and views at the same time, import data into SQL server from different file types, variety of import mode types, such as append, update, et cetera.
Let's get started. Upon starting the application, the New Project window will show up first. First, under the Data Source tab, set the SQL server. Then set the authentication type for the SQL server. For purpose of this video, the Windows authentication will be used. Next step is to choose the database under the Database dropdown list. Clicking the Next button will guide us to the Action tab, which will show the Export and Import options.
The Export option is able to export data from SQL database to different file formats. And the Import option can import data from different files into the SQL database. First, we will use the Export feature to show how SQL data can be exported to the different file formats. Click the OK button to load the database data in the main grid. By default, the Show All option is chosen. And the All SQL Data will be checked.
For the purpose of this video, only some of the SQL data will be checked. And we will switch to the Show checked mode to see only what we want to export. On the right side in the Preview panel, the SQL data is shown. Note, the Preview panel can be moved to the different positions in the application. Before we start to export the data, an export file format needs to be chosen by clicking the Manage button from the Home tab.
Under the Manage Export window, there are three tabs. In the Formats tab, one of the available output file types can be selected. Under the Rows tab, it can be chosen how many rows of data will be exported. To export all data rows, select the All Rows radio button. To export just certain numbers or rows, select the Range radio button. And in the Start and Finish boxes, enter a started and ended number of the rows.
The last tab in the Manage Export window is the Additional scripts tab, where the pre or post-processing scripts can be included. For the purpose of this video, we will go back to the Formats tab. Choose the HTML export format and open the settings for it under the. HTML options window, there are the basic and additional tabs, where the options such as header, borders, data rows, and data formats can be set.
When everything is set in the HTML options window, there is the Preview button and on the bottom right side to check if the desired settings are set before the export process is started. Using the Preview button will show in the default browser how the export HTML file will look like for the checked SQL table from the main grid, in this case, the Human Resources Department table. If everything is OK, proceed by clicking the OK buttons in the HTML options and in the Manage Export windows.
Now, the next step is using the Process button from the Home tab. The job summary window will be shown to check if everything is correct. Our example shows that one table will be exported including four columns. Click the Export button to start exporting the SQL data. When it's finished, the View Results window will be shown with the complete summary of the export process. Here, can be seen the duration of the exporting process, exported tables, exported columns, and exported rows.
If wanted, the export results can be exported or a report can be created by clicking Export Results or Create Report buttons. The next that will be shown is an import action from the application. Using the New Project window, again, the connection, authentication, and database have to be set. And then proceed to the import action by clicking the Next button. In this action tab, choose the import option and click the OK button.
When the SQL database is loaded, it will be shown in the main grid. Once the main grid is shown with SQL objects, the first step is to add import sources by clicking the Manage button from the Home tab. The Manage Import window contains two tabs. The first one is the Format tab, where the import source needs to be added. And the second one is the additional scripts tab for potential adding the pre and post-processing scripts.
In this example, for the import source, the file that we exported in the previous example will be used. Clicking the Add button under the Format tab will open the window where the import data source between SQL database and file can be chosen. For this example, the file data source will be used. And the HumanResources.Department.html will be loaded as the import source.
To continue the process, click the OK button in the Manage Import window. And it will show you again the main grid. To map the table or the column, please select from the main grid a desired one. In this case, the Person.CountryRegion table is selected. The selected table will be mapped by loaded imported source file, HumanResources.Department. And to do that, go to the Settings panel on the right side of the application. And under the mapping section, click the dropdown menu and select the mentioned