[DERBY-1651] Develop a mechanism to migrate mySQL databases to Derby. Migration tool should include both schema and data migration options.

• Type: Improvement
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Tools
• Environment: All platforms
• Assignee: Unassigned
• Reporter: Ramin Moazeni
• Created: 05/Aug/06 06:40
• Updated: 01/Jul/09 00:34

Description

Develop a mechanism to migration databases created by other database engines to Derby. While my current interest is to migrate mySQL databases to Derby, the tool could be developed in a way to extend this mechanism to allow migration from other database engines in the future.

More details of proposed functionality and implementation strategy can be found at:
http://wiki.apache.org/db-derby/MysqlDerbyMigration

The plan is to develop and submit patches incrementally. First patch supports migration of tables and views from mySQL database to Derby.

Issue Links

• relates to: DERBY-716 Re-enable VTIs