What is EMS Data Pump for SQL Server?
EMS Data Pump for SQL Server is an excellent migration tool for converting databases and importing table data from an ADO-compliant source (for example, MS Access, MySQL database, or any other ADO-supported database) to SQL Server databases.
The easy-to-use wizard application lets you create the ADO connection string, select tables, fields, and indexes to convert, view, and edit the SQL script to generate the target SQL Server database, and fully customize the import process. Data Pump for SQL Server has the ability to automate migration to the SQL Server task using the useful console utility. With Data Pump for SQL Server, converting and migrating the database to SQL Server becomes as easy as possible!
Core features
- Wizard-friendly interface.
- Converting structure and data from any local and remote data source with an ADO provider.
- Unicode media.
- Selecting schemas, tables, fields, and source indexes for conversion.
- Quick generation of tables, fields, and indexes according to the structure of the source database.
- Easily customizable options for target database objects.
- Ability to view/edit, run and save SQL scripts to generate the target database structure.
- Selecting tables and defining criteria for data import.
- Complete monitoring of the pumping process.
- Ability to save all parameters specified in the current wizard session as a template.
- Multilingual GUI support.
- Command-line utility to automate data pump work with the help of a model file.
- Ability to create a new SQL Server database or connect to the existing one.
- Ability to specify schema for target database tables.
System Requirements
- 300 MHz processor; Recommended 600 MHz (MHz) processor
- Microsoft Windows NT4 com SP4 ou posterior, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10
- 64 MB of RAM or more; 128 MB or more recommended
- 20 MB of available HD space for program installation
- Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended
- Microsoft mouse or compatible pointing device
- MDAC (Microsoft Data Access Components) ou SQL Server Native Client
- Ability to connect to any local or remote SQL Server as a destination and an ADO-compliant source
