Derby
  1. Derby
  2. DERBY-1651

Develop a mechanism to migrate mySQL databases to Derby. Migration tool should include both schema and data migration options.

    Details

    • Type: Improvement Improvement
    • Status: In Progress
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None
    • Environment:
      All platforms

      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

          Activity

          Ramin Moazeni created issue -
          Ramin Moazeni made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          Satheesh Bandaram made changes -
          Environment All platforms
          Summary MySQL to Derby Migration Tool Develop a mechanism to migrate mySQL databases to Derby. Migration tool should include both schema and data migration options.
          Description This is the first drop of MySQL to Derby Migration tool. There is currently support for tables and views. 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.
          Fix Version/s 10.2.0.0 [ 11187 ]
          Ramin Moazeni made changes -
          Attachment DBMigration.diff [ 12338896 ]
          Andrew McIntyre made changes -
          Derby Info [Patch Available]
          Rick Hillegas made changes -
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Fix Version/s 10.2.1.0 [ 11187 ]
          Mike Matrigali made changes -
          Derby Info [Patch Available]
          Rick Hillegas made changes -
          Fix Version/s 10.2.3.0 [ 12312215 ]
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Andrew McIntyre made changes -
          Fix Version/s 10.2.3.0 [ 12312215 ]
          Rick Hillegas made changes -
          Link This issue relates to DERBY-716 [ DERBY-716 ]
          Kathey Marsden made changes -
          Assignee Ramin Moazeni [ moazeni ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Gavin made changes -
          Workflow jira [ 12379582 ] Default workflow, editable Closed status [ 12801439 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Ramin Moazeni
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Development