MySQL Visual Database Migration Tool

Nothing like good timing. I am working on a project with a company right now who has elected to migrate more than 30 Microsoft Access databases of various size and complexity used internally and on the web to MySQL 4.

To my own and all of our good fortunes — MySQL AB today announced the free availability of the MySQL Migration Suite. This GUI toolset will allow for comprehensive migration from Oracle and Access initially (with Microsoft SQL Server, IBM DB 2 and others to follow) and is released under the GPL 2 license.

Better yet it is written in Java, meaning one can perform cross-platform database migrations (Unix to Windows, Solaris to Linux and so on). The Suite utilizes time-tested methodologies and a Wizard guide to cover all the basics of migration as well as stored procedures and triggers.

With its handy reporting capabilities, audits and due diligence can be performed on migrations as they are expedited to insure no missing links are passed over.

I am going to do some test migrations in my development environment as taking anything brand new into production can be interesting to say the least. However – this looks to save some serious time and potential headaches.

Breaking with my habit of not mentioning the products I use – normally I have used Navicat during the migration process as it also spans multiple operating systems (specifically Linux, Mac and Windows). It has done its job superbly – however – the MySQL Migration Suite being GPL open source – I absolutely have to give it a run through the paces to see how it performs.

With Navicat 7 pending release and adding several features I felt were missing from version 6 – it may keep me from adopting the MySQL Suite. However, it will not keep me from giving it a good bench test on this current Access project!

For those who also work with MySQL in a commercial capacity (paying for MySQL services or licensing) — the company is also offering quite an appealing $1500 discount on their own consulting services for getting a 5-day kickstart with MySQL 5 deployments.

Replay

Category: open source Time: 2005-04-20 Views: 2
Tags:

Related post

  • Visual database design tool for MySQL 4.* 2014-10-15

    I am looking for a visual database design tool that: integrates SQL development can browse databases and tables graphically supports the connection method TCP/IP over SSH (like MySQL Workbench) supports MySQL 4.* (unlike MySQL Workbench) works on Win

  • Where is MySQL Workbench Database Migration Wizard? 2013-02-25

    I am using MySql 5.5 with MySql Workbench 5.2 CE. I have read that workbench has data migration feature (http://www.mysql.com/why-mysql/migration/), but I am not able to find this feature in workbench. Please tell me Where is MySQL Workbench Database

  • Migrating from Oracle to MySQL using WorkBench Migration Tool 2013-02-13

    I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database System: Generic RDBMS Connection Method: ODBC(Manually

  • Is it okay to integrate database migration tools like Flyway, Liquibase with the application code base? 2016-01-20

    I mean is it good practice to allow application to modify the db? Or should database migration be done externally to the application code base? New to this, so any input will be appreciated. We are using java and gradle to build the application. ----

  • Database migration tool for GoDaddy Managed WordPress 2015-06-16

    I'm about to revoke my Managed WordPress subscription because tools that I have paid for (such as WP Migrate DB Pro) that are an integral part of my development process that sync or migrate my local development WP database over to my staging or produ

  • Converting a large SQL Server database to MySQL. Database corruption? Can't access data after transferring 2012-07-03

    I have gigabytes of tabular data stored in a SQL Server database. I've been trying to migrate it to MySQL using the Migration Toolkit from Oracle. I didn't have any mapping errors and fixed all the syntax mismatches, so now the rows are being transfe

  • mysql Migration Tool 2012-07-14

    I would like to use the migration tool to migrate all databases to a new server. I want to use root as username to migrate the db's to the new server but I can't use this account because the ip address of the pc where the tool is on is not allowed. H

  • Tip for a good Database Converter Tool 2010-08-21

    I need often to convert a database from a database server to another, for example convert a database in MSSQL to a PostgreSQL or convert a MySQL to PostgreSQL, but also convertion between MySQL and Firebird. Is there a good tool that allow to convert

  • Are there any free online collaboration database schema tools? 2011-10-31

    I am interested in a free and simple MySQL tool which can offer online collaboration functionality in creating database general schema. Do you know any? --------------Solutions------------- You can use Vertabelo. Vertabelo is an online database desig

  • Logical schema development and migration tool for different physical schema available including triggers and stored procedures? 2011-12-01

    We are planning to support for our application another rdbms (oracle). At the moment we are design our database schema with the MySQL-Workbench. For every new database version we have schema er-diagram a full schema sql script (create table.., create

  • Is it possible to Clone an Existing MYSQL Slave Database into Amazon RDS with the RDS clone being a slave to an external Master? 2015-09-16

    We are interested in migrating our data from one of our MYSQL slave databases to an Amazon RDS instance such that the new RDS database is a slave database to an external master DB from our colocation/facility. I was reading through the documentation

  • Questions concerning Migration Tool 2015-04-01

    Hi, so far I have been reluctant to update our servers to Jessie, but I am in great hope that your migation tool will provide a way that spares me of some of my headaches with the move. I only have two minor questions left: Currently we have two serv

  • Determining how much RAM I will need for processing a database migration 2009-10-29

    I am trying to determine how much RAM is going to be required for processing a database migration (company wishes to purchase more RAM for me). The factors are: Approximately 3 GIG's of data being transferred between Oracle and MySQL Approximately 90

  • Migration tool for specific lists 2011-12-14

    I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if I have: a list of company names a list of offices,

  • How do I automatically backup Mysql-Cluster database? 2012-05-08

    I need to automatically and frequently backup Mysql-cluster databases. How can I do this? --------------Solutions------------- MySQL Cluster includes an on-line backup tool that can be executed manually or via a script. For more information read the

  • Postgres database migration "zero" downtime 2014-02-18

    I have a setup with a JBoss EAP server, postgres 9.1 database. I will soon update so I have two JBoss servers in a cluster. This is mostly to avoid downtime when doing application deployments. With the database as a single point of failure, how can I

  • Custom migration tools from Lotus notes to SharePoint 2014-04-12

    I need to know steps involved to migrate lotus notes data to SharePoint through a custom migrator tools. I know only few steps: use c++ or VC++ (?possible) to connect to lotus notes tools through OLE provider. develop COM component which bridges gap

  • Set up MySQL server database 2015-05-06

    I want to set up MySQL server database for my office on my windows 8 pc, but i dont know exactly which products to use. Can anybody help me with it. I want to set the database such as my pc would be the server pc and i can manage the database tables

  • Database migration script 2015-10-15

    I'm working on a database migration script written in python, which will take data from a MySQL database and insert them into a PostgreSQL database with a different Schema (different table structures, different datatypes and so on). Performances does

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.544 (s). 13 q(s)