Re: MySQL as middleware
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.
Subject
Written By
Posted
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.