Bug #54731 migration wizard
Submitted: 23 Jun 2010 10:04 Modified: 19 Jul 2012 6:40
Reporter: haris neziric Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: migration, wizard

[23 Jun 2010 10:04] haris neziric 
Description:
i'm currently manually writing queries to migrate data from one database to another. data is more or less the same, with some minor variations, but table structures are different.

it would be great if you guys could add a migration wizard to workbench, that looks like a reverse engineer wizard for example.

it should have steps to select 'from' and 'to' databases, select tables, fields and filter data.

filters would just override data, so if userType=1 in old db, in new it should be set to 3 for example.

what do you think?

How to repeat:
 ^^
[19 Jul 2012 6:40] Philip Olson 
This has been fixed as of the soon-to-be-released Workbench 5.2.41, and 
here's the changelog entry:

MySQL Workbench added a migration wizard, which will migrate ODBC compliant
databases to MySQL.