FezEvils Posted January 29, 2009 Share Posted January 29, 2009 hello everyone, last week i got a project about inventory, the current system is using ORACLE as a database. But the client want to change the whole system into MySQL+PHP. yesterday, i have convert the oracle db to mysql. but the dump file for oracle only contains structure data only.. so help me, if is it other way to migrate all data ib oracle db into mysql using the same data structure? Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/ Share on other sites More sharing options...
Mchl Posted January 29, 2009 Share Posted January 29, 2009 Most likely it is. You should search on how to perform full database dump from Oracle. Preferably in format that can be digested by MySQL. (Or CSV if everyone else fails). Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749394 Share on other sites More sharing options...
FezEvils Posted January 29, 2009 Author Share Posted January 29, 2009 ok.. what if i change my question a little bit.. i got 2 db now 1 is oracle and other one is mysql. both have same data structure , but only oracle have data, so how to migrate without dumpping? Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749396 Share on other sites More sharing options...
Mchl Posted January 29, 2009 Share Posted January 29, 2009 .... You don't? Â I mean... how do you want to migrate your data without migrating your data? Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749401 Share on other sites More sharing options...
FezEvils Posted January 29, 2009 Author Share Posted January 29, 2009 what i means is, both db have same structure , but the oracle is on main server in head quarters, so they just give me password and username for the connection only. oracle has all the data, but mysql is empty, so i need to copy all data from oracle to mysql without copying the data structure once again.. that gave me headache.. Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749413 Share on other sites More sharing options...
Mchl Posted January 29, 2009 Share Posted January 29, 2009 Well then... I suppose you could select all data from all tables using "SELECT * FROM table", store the results on your HDD, and then insert them into MySQL... This could be tricky though... Â Seriously, won't they give you the datadump from Oracle? You should charge them extra. Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749418 Share on other sites More sharing options...
FezEvils Posted January 29, 2009 Author Share Posted January 29, 2009 that why i got headache!! they only give me the structure without data, maybe i should them to give me dumpfile from oracle.. for dump data, i use oradump (sourceforge.net/projects/oradump ). do you have any suggestion mysql migration tools? Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749428 Share on other sites More sharing options...
Mchl Posted January 29, 2009 Share Posted January 29, 2009 Never worked with Oracle, so I know no tools for migration from Oracle to MySQL. Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749435 Share on other sites More sharing options...
FezEvils Posted January 29, 2009 Author Share Posted January 29, 2009 that ok... 1 question, how to mark this topic as solved Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749445 Share on other sites More sharing options...
Mchl Posted January 29, 2009 Share Posted January 29, 2009 http://www.phpfreaks.com/forums/index.php/topic,118755.0.html Quote Link to comment https://forums.phpfreaks.com/topic/142934-solved-mysql-migration/#findComment-749446 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.