Re: MySQL as middleware
Posted by: Sergio de la Cruz
Date: March 27, 2012 08:03AM

Without further details it would be very difficult to give you valuable answers. It would be very good if you could elaborate a bit more about your current scenario.

Having said all that, here are some general advices:

* There's an old MySQL Migration Toolkit (http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0-r17-win32.msi/from/pick#mirrors) to help you migrate from other RDBMSes into MySQL. It could be a starting point. I would advise you to be cautious with its use (or with the use of any automatic migration tool).

* There's a white paper called "A Practical Guide to Migrating From Microsoft SQL Server to MySQL" (http://dev.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php) that should cover the key areas of the migration process.

* You can take advantage of high level scripting languages like Python to achieve data verification and other scriptable tasks/tests.

* Keep an eye on the MySQL Utilities (shipped with MySQL Workbench). Here you can find more information: http://larsthalmann.blogspot.mx/2011/04/mysql-workbench-utilities.html

Hope this helps.

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.

Options: ReplyQuote


Subject
Written By
Posted
March 23, 2012 07:31AM
Re: MySQL as middleware
March 27, 2012 08:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.