General
What are the system requirements for ApexSQL Pump?
Please see the following link
Are there any restrictions to the trial version of the tool?
No, ApexSQL Pump is fully functional for 14 days
Is there a limit to the number of SQL server tables/views that can be imported/exported?
No, virtually there is no limit to the number of objects that tool can process
What SQL Server editions are supported?
ApexSQL Pump supports SQL Server Express, Standard, and Enterprise editions
What SQL Server versions are supported?
Microsoft SQL Server 2019 2017, 2016, 2014, 2012, 2008, and 2005
Export
What file types are supported when exporting data from SQL server?
ApexSQL Pump support 13 different file types: csv, database, html, json, MS excel, MS word, ods, odt, pdf, rtf, SQL, text, xml
Can I share my export settings with my team by export/import?
Yes, under export settings there are import and export button that can be used for sharing settings
Can I filter rows that I want to export?
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
Can I execute additional scripts before and after my data is exported?
Yes, ApexSQL Pump support pre and post script execution both from T-SQL query and script file
Can I preview export data before exporting to SQL server?
Yes, under the export settings there is a preview button that shows preview based on settings
Can I see export summary before my process begins?
Yes, when process button is pressed in main form export summary is shown
Import
What file types are supported when importing data from SQL server?
ApexSQL Pump supports 11 different file types: csv, database, html, json, MS excel, MS word, ods, odt, SQL, text, xml.
What import modes are supported by ApexSQL Pump?
ApexSQL Pump supports 5 different import modes: insert new, re-populate, update, update and/or create new, delete
Is there a limit to the number of imported files?
No, virtually there is not limit to the number of files used in data import process
Can I preview import data before importing to SQL server?
Yes, under the manage import preview can be done by selecting import file
Can I preview export data before exporting to SQL server?
Yes, under the export settings there is a preview button that shows preview based on settings
Can I see import summary before my process begins?
Yes, when process button is pressed in main form import summary is shown
Processing
Can I see a summary of the results after data import/export is done?
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
Can I automate the process of import/export?
Yes, ApexSQL Pump supports CLI both batch and PowerShell
Options
Does ApexSQL Pump recognize CHECK constraints?
Yes, ApexSQL Pump recognize CHECK constraints and can pre-emptively disable them
