“The latest version of MySQL Workbench has a new migration wizard designed to provide an easy way to migrate databases from third party products to MySQL.
This first version of the wizard lets you migrate from Microsoft SQL Server and from databases supporting ODBC such as PostgreSQL.”
see Oracle offers route from SQL Server to MySQL.
The new migration feature is available in MySQL Workbench 5.2:
“The MySQL Workbench Migration Wizard is designed to save DBA and developer time by providing visual, point and click ease of use around all phases of configuring and managing a complex migration process:
Migration project management – allows migrations to be configured, copied, edited, executed and scheduled.
Source and Target selection – allows users to define specific data sources and to analyze source data in advance of the migration.
Object migration – allows users to select objects to migrate, assign source to target mappings where needed, edit migration scripts and create the target schema.
- Data migration – allows users to map source and target data and data types, set up data transfer and assign post data transfer events where needed.
It’s already part of Debian GNU/Linux, Wheezy version.
“dpkg -s mysql-workbench
Status: install ok installed
Maintainer: Dmitry Smirnov
Source: mysql-workbench (5.2.40+dfsg-1)
One more bit of lock-in bites the dust. I like it…