FlySpeed DB Migrate to MySQL 2.2

FlySpeed DB Migrate to MySQL 2.2 helps you to effectively transfer databases from any engine to MySQL Server.

FlySpeed DB Migrate to MySQL/SQL Server expedites the migration from your current database engine into MySQL. 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! Dont 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.
   • Ability to log the whole migration process.
4. 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 programatically via OLE Automation.

Enhancements:

• The new option is added to rollback all changes in the database when error occurs during the data transfer.
• Code optimization is made. Data transfer speed might be increased up to 15 percent.
• Other minor bug fixes and improvements.

Requirements:OLE DB Provider or ODBC Driver for the Source database

 WareSeeker Editor