EMS Data Pump for SQL Server is a software utility designed to convert databases and import table data from any ADO-compatible source (such as MS Access, MySQL, or other databases with ADO support) into Microsoft SQL Server databases. It provides a user-friendly wizard for configuring migrations, selecting tables and fields, editing SQL scripts, and automating the migration process via command-line utilities. The tool is suitable for both local and remote data sources and supports customization of the import process.

Key Features

User-friendly wizard interface Guided steps for configuring and executing database migrations

• Build ADO connection strings easily
• Select tables, fields, and indexes for conversion

Support for ADO-compatible sources Import from any local or remote database with an ADO provider

• Compatible with MS Access, MySQL, and others
• Unicode data support

Customizable conversion and import Flexible options for target database structure and data

• Edit, execute, and save SQL scripts for target databases
• Specify schemas for target tables

Automation and templates Automate migration processes and reuse configurations

• Command-line utility for automated jobs
• Save wizard session parameters as templates

Monitoring and reporting Track and review the migration process

• Full monitoring of data pumping
• Multilanguage GUI support

Database creation and connection Work with new or existing SQL Server databases

• Create new databases or connect to existing ones

Benefits

Simplifies complex migrations Reduces manual effort and risk during database migration

• Easy-to-use interface minimizes errors
• Automates repetitive migration tasks

Flexible and customizable Adapts to various migration scenarios and requirements

• Supports selective conversion of schemas, tables, and fields
• Customizable SQL script editing

Saves time and resources Accelerates the migration process and reduces downtime

• Fast generation of target database structures
• Ability to automate recurring migration jobs

Comprehensive support and updates Ensures continuity and assistance for users

• Includes one year of free maintenance and technical support
• Free updates and upgrades during maintenance period