Porting from Oracle to MySQL
A potential customer asked my about porting her application from Oracle Database to MySQL.
I always try to start with the "why" (a dear friend bought me this book, recommended: http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).
She said "cloud!". I said "OK!".
I conducted a short research, found many things in many places all over the place, brought them to a nice email I sent her back and then thought I'll post it here and make it public as it might be useful for us all. If you feel that I missed something, add comments, send feedback.
These are the leading tools to do the actual migration of the data structure, data export/import, sprocs, triggers, etc.:
- MySQL Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
- MySQLYog can be used to migrate: http://tkurek.blogspot.com/2013/04/migrate-oracle-to-mysql.html (already in the conversation in the second comment there)
- Navicat can be used to migrate: http://www.navicat.com/products/navicat-for-mysql
- Tungsten support Oracle-to-MySQL replication: http://www.continuent.com/downloads/software
- Focused data migrators:
- http://www.ispirer.com/products/oracle-to-mysql-migration
- https://www.youtube.com/watch?v=IW3vKHWJljY
- http://www.slideshare.net/Tess98/oracle-to-mysql-migration-presentation
- http://www.dbload.com/
- http://dbconvert.com/convert-oracle-to-mysql-pro.php
- http://www.spectralcore.com/omegasync/
The way I see it, migrating the data is 15% of a database porting project. Efforts are in (partial list):
- Porting drivers and driver behavior in the app code
- Porting SQL commands all around the app code
- Conversion of non-standard SQL flavor
- Work-around restrictions and non-supported commands
- Ecosystem, monitoring, tuning, tools, scripts, hardware best practices, ops skills, dev skills
Way before the migration of the data on d-day.
A lot of services, some tools. Services-wise I see around:
- Pythian: http://www.percona.com/live/mysql-conference-2012/sessions/oracle-mysql-migration
- Baron (Percona): http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
I bet the big SIs (Accenture et al) are strong in this game, as those would be the default go-to service provider for the Oracle shops.
http://database-scalability.blogspot.com/2014/04/porting-from-oracle-to-mysql.html#.VJgussAOA
最新文章
- [PHP源码阅读]strlen函数
- MS SQL 日常维护管理常用脚本(二)
- .NET Core Web 应用部署到 Docker 中运行
- JavaScript 写几个简单的知识点
- editplus的配置和使用
- Storage Systems topics and related papers
- Struts2的处理结果（一）——处理结果的配置
- ArcGIS API for JavaScript 学习笔记（一）
- 执行mysql脚本
- 偷偷mark下一个
- ASP.NET的三层架构(DAL,BLL,UI)
- TortoiseGit - 分支管理 -增加分支
- 图论之最短路径floyd算法
- WinRAR存在严重的安全漏洞影响5亿用户
- Chapter 5 Blood Type——9
- List的分组，求和，过滤操作
- 前端开发面试题总结之——JAVASCRIPT（三）
- c# 动态绘制直线和曲线
- delphi 条形码
- AspNetCore+Swagger 生成Model描述