FlySpeed DB Migrate to MySQL 2.4

FlySpeed DB Migrate to MySQL 2.4 is a software designed for transfering databases from any engine to MySQL Server quickly and reliably, which expedites the migration from your current database engine into MySQL.

FlySpeed DB Migrate to MySQL is a timesaver for database migration to MySQL and data transfer tasks. It successfully copes with two main problems occurred during migration to MySQL database server from another:

• Full transfer of the database tables structure and data in regards to all the fine points of the MySQL database server
• Data transfer into already existing MySQL tables with ability to maintain data actuality afterwards (single-side synchronization).

The tool to move your database to MySQL at one sight. FlySpeed DB Migrate to MySQL provides rapid data migration across databases ensuring lossless data integrity. It allows modification of a MySQL database structure and data with ease. With FlySpeed DB Migrate, you gain the control you need during the migration process.

The tool for everyday data transfer to MySQL.FlySpeed DB Migrate to MySQL is not a one-time utility but a set of Power Tools to automate your data movement and synchronization tasks. Saving all migration options to a file, you may easily repeat your task in a few mouse clicks. The Command-line tool and the Task Scheduler let you automate your data transfer completely.

This software migrate your entire database complete with structure and data quickly and efficiently, or transfer data from the source database into an existing structure. The data transfer mode allows performing one-way database synchronization as many times as you need. FlySpeed DB Migrate is not a use-it-once data-transfer utility. The product offers powerful options for database synchronization and regular maintenance.

Need a local backup of your Web database? Migrate your Web database onto the local PC, and keep it up-to-date with regular data transfer! Do not have a direct connection to the remote database? No problem! FlySpeed DB Migrate will create a compatible SQL script that you can execute on the remote PC to perform the transfer.

If you have a direct connection to the source database, FlySpeed DB Migrate really shines offering unprecedented speed and complete control over the migration process. Need a completely automatic transfer? Youll get it done in no time! Require full control over the operation? You can make any changes to the tables and object structure before the transfer begins, and control the migration process while it runs. Should an error occur, you can fix it in-place and continue on from where it stopped.

FlySpeed DB Migrate is very compatible, and can import data from any type of database regardless of its engine. The product can access your source database via ADO or ODBC, extracting maximum information about the database structures and data. If you are migrating from databases such as MySQL, PostgreSQL, or Firebird, an ODBC access is highly recommended due to increased speed and quality of the transfer.

Major Features:

1. Different modes of database migration and data transfer
   • Complete transfer of database tables structure and data from the source to the destination database servers.
   • Transfer of selected database objects and schemas only.
   • Transfer data into existing tables within the destination database.
   • Transfer new/updated/deleted records only (single-sided data synchronization).
   • Generation of an SQL script for future execution on the destination MySQL server.
2. Import database schema and data from any OLE DB or ODBC data source
   • Import database structure and data from standalone database servers: MS SQL Server, MySQL, Oracle, DB2, Sybase, Informix, PostgreSQL, InterBase, Firebird and other.
   • Import database structure and data from desktop databases: Paradox, FoxPro, DBF.
   • Import data from popular office formats (though ODBC driver): Excel, CSV, TXT.
   • Direct import from MS Access databases, including correct image extraction from OLE BLOB fields.
   • Full Unicode support.
3. High customization, full control over the migration process.
   • Extracting full metadata information available (tables, fields, PK, FK and indices).
   • Selecting source objects to extract metadata and to move data from.
   • Full customization of the target database and objects.
   • Quick filtration of transferred data.
   • Wide range of SQL Script generation options.
   • Ability to view and edit a generated SQL script.
   • Full monitoring and control over the database generation process.
   • Ability to stop when encountering an erroneous SQL statement, correct it and resume.
   • Ability to rollback all changes in the database when error occurs during the data transfer.
   • Ability to run additional SQL scripts before and after the import process.
4. Ability to log the whole migration process.
5. Advanced features (available in Professional version only)
   • Saving all current session settings to the project file for repeated use.
   • New: Command-line tool to run data transfer projects in a single click.
   • New: Task Scheduler to automate your data transfer tasks.
   • New: COM Server to run the command line tool programmatically via OLE Automation.

Enhancements:

• Ability to create portable installations is made.
  
• Task Scheduler: Ability to run the task once at scheduled time is added.
  
• Ability to create scheduled task on saving a project is made.
  
• Now it is possible to provide username and password for ODBC connections.
  
• Other minor improvements.

Requirements:

• OLE DB Provider or ODBC Driver for the Source database