Online Documentation for Data Pump for SQL Server

EMS Data Pump FAQ


Please read this page attentively if you have questions about EMS Data Pump for SQL Server.

 

Table of contents

 

Question/answer list

 

Q: What is EMS Data Pump?

A: Data Pump for SQL Server is an excellent utility for converting databases and importing table data from any ADO-compatible source (e.g. MS Access or any other database with ADO support) to SQL Server databases. The easy-to-use wizard application allows you to build the ADO connection string, select the source tables, fields, indices and constraints for converting, view and edit the SQL script for generating target SQL Server database, select tables to be imported and customize a number of pump options.

 

Q: What do I need to start working with EMS Data Pump?

A: First of all, you must have a possibility to connect to some local or remote SQL Server to work with Data Pump. You can download SQL Server from https://www.microsoft.com/downloads/. Besides, you need your workstation to satisfy the system requirements for Data Pump for SQL Server.

 

Q: What is the easiest way to configure the template files for the MS SQL Data Pump console application?

A: You can configure the template files visually using the MS SQL Data Pump wizard. Set the required   pump options at of the wizard, click the 'Tools' button and select the 'Save Template' popup menu item. All the options will be saved to the template file which can be used later in the console application.

 

Q: How can I register the product?

A: If you have already purchased Data Pump for SQL Server, you can register the product by entering the appropriate registration information. Please refer to Registration and How to register EMS Data Pump for details.

 

Q: Are there any limitations implied in the trial version as compared with the full one?

A: The trial version of the utility admits to the maximum of 10% of records to be imported for each table. In all other respects it does not differ from the full version as far as the functionality is concerned. That is, you can test all the features implemented in Data Pump for SQL Server within the 30-day trial period.

 

Q: I’m trying to import data from MS Access. When I expand a table node, it shows indices(0), constraints(0) and I cannot select them. How can I fix this?

A: The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your source Access database.

 

Q: I'm testing Data Pump utility to convert a MS Access 2000 database to MS SQL but it raises an error of access violation in module msjet40.dll.

A: Try to reinstall the Microsoft Data Access Components (MDAC) 2.8 which can be downloaded from https://www.microsoft.com/downloads/search.aspx?displaylang=en

 

 

Q: I create a database schema for the target server, go through the steps of the wizard, do not execute script at Step 5 and the available tables and selected tables panels are empty too. The Next button is disabled. What is wrong here?

A: This issue arises because of differences between the generated script and the schema already in existence. The problem is that some table names or field names may differ from the ones generated by Data Pump (the correspondence between the source and the target tables is verified by tables' and their fields' names). If your new (target) database structure differs from the source database structure, no objects will be available in the Available Tables and the Selected Tables lists at Step 7. The source metadata must match the target metadata for successful data import script execution.

 

Scroll to top

 

If you have any additional questions, contact us at our Support Center.