 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Oracle / Oracle Server / April 2008mysql -> Oracle
We have to look at ,igrating data from an existing system that was built using mysql. Was in two minds where to post this to or whether to cross- post but decided to ask here first. Does anyone know of any utilities that will enable a mysql schema to be loaded into Oracle (we're talking 9iR2 and/or 10gR2 here)? It doesn't have to be sophisticated (no problem to have manual steps) but would be great if can be achieved. Thanks for all suggestions.  Signaturejeremy > We have to look at ,igrating data from an existing system that was built > using mysql. Was in two minds where to post this to or whether to cross- [quoted text clipped - 9 lines] > -- > jeremy maybe you'd gvve SQL Developer Migration Workbench a try. Take a look at http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html best regards Markus Tazl In article <86ca5928-fb46-4823-98b9- f6c4b971b20b@c58g2000hsc.googlegroups.com>, Markus Tazl says... > maybe you'd gvve SQL Developer Migration Workbench a try. Take a look > at http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html Thanks you that looks interesting. Signaturejeremy jeremy <jeremy0505@gmail.com> wrote in news:MPG.227d7af1f7ae40e698a4e2 @news.individual.net: > We have to look at ,igrating data from an existing system that was built > using mysql. Was in two minds where to post this to or whether to cross- [quoted text clipped - 7 lines] > Thanks for all suggestions. > If I was given this task I'd write a simple PERL program to move the data from MYSQL to Oracle. Do you have any MYSQL datatypes that do not cleanly map to Oracle? > If I was given this task I'd write a simple PERL program to move the data > from MYSQL to Oracle. Different servers, different providers. Ideally we'll just find a simple method of "exporting" the MySQL schema as DDL scripts whichy are oracle- compatible and likewise a set of insert statements per table, again oracle-friendly. > Do you have any MYSQL datatypes that do not cleanly map to Oracle? Not sure at the moment - haven't had sight of the MySQL schema. We are only going to load the data into a holding schema and then run transformations to load into our application tables. Signaturejeremy > We have to look at ,igrating data from an existing system that was built > using mysql. Was in two minds where to post this to or whether to cross- [quoted text clipped - 9 lines] > -- > jeremy I once transferred data from mysql to oracle using oracle's hsodbc to define a database link from oracle to mysql. Don't know if it's the right tool for your task, but maybe it's worth a look ... In article <d4559793-657d-48ff-93df-003b1ba6b752 @a1g2000hsb.googlegroups.com>, steph says... > I once transferred data from mysql to oracle using oracle's hsodbc to > define a database link from oracle to mysql. Don't know if it's the > right tool for your task, but maybe it's worth a look ... Thanks will take a look into this as well. Signaturejeremy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.