EMS logo

Products Navigation

Data Pump for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Pump for SQL Server

Product FAQs

Table of contents

Q:
What is EMS Data Pump for SQL Server utility?
A:
EMS Data Pump for SQL Server is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to Microsoft® SQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target Microsoft® SQL database and select tables for import. Data conversion becomes as easy as possible with EMS Data Pump for SQL Server!
Q:
What do I need to start working with EMS Data Pump for SQL Server?
A:
First of all you must have an opportunity to connect to some local or remote SQL Server. Besides you need your computer to satisfy the system requirements of EMS Data Pump for SQL Server.
Q:
I‘ve downloaded a trial version of EMS Data Pump for SQL Server, but not all records of the tables are converted. What’s the reason for this?
A:

This is a limitation of the trial version which converts only 10% of all records. With a registered version all the records are processed.

Q:
I’m trying to import data from MS Access. When I open up a table 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 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. You can download it from the page http://www.microsoft.com/downloads/search.aspx?displaylang=en