For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Pump FAQ

General

No, ApexSQL Pump is fully functional for 14 days

No, virtually there is no limit to the number of objects that tool can process

ApexSQL Pump supports SQL Server Express, Standard, and Enterprise editions

Microsoft SQL Server 2019 2017, 2016, 2014, 2012, 2008, and 2005

Export

ApexSQL Pump support 13 different file types: csv, database, html, json, MS excel, MS word, ods, odt, pdf, rtf, SQL, text, xml

Yes, under export settings there are import and export button that can be used for sharing settings

Yes, row filtering is done in row tab in the manage import window. Currently two types of row filtering is available: using range or using where clause

Yes, ApexSQL Pump support pre and post script execution both from T-SQL query and script file

Yes, under the export settings there is a preview button that shows preview based on settings

Yes, when process button is pressed in main form export summary is shown

Import

ApexSQL Pump supports 11 different file types: csv, database, html, json, MS excel, MS word, ods, odt, SQL, text, xml.

ApexSQL Pump supports 5 different import modes: insert new, re-populate, update, update and/or create new, delete

No, virtually there is not limit to the number of files used in data import process

Yes, under the manage import preview can be done by selecting import file

Yes, under the export settings there is a preview button that shows preview based on settings

Yes, when process button is pressed in main form import summary is shown

Processing

Yes, after data import/export process is completed the result dialog appears and user is able to see the summary, create report and export results to text file

Yes, ApexSQL Pump supports CLI both batch and PowerShell

Options

Yes, ApexSQL Pump recognize CHECK constraints and can pre-emptively disable them