how to convert oracle to mysql
Hi Guys,
One way to do it is to query the object's structure trough SQL using JDBC, then you will have all the information you need available in Record sets (data-types, names...)In Oracle in order to get all tables (or other types of objects) you can:
SELECT Object_Name,Object_ID FROM user_objects WHERE Object_Type='TABLE'
Then you can iterate trough the resulting Recordset and for each table you have gotten on the previous query. get the column structure like this:SELECT * From user_tab_columns WHERE Table_Name='TableName'This way you can conditionaly build up Create table statements with proper datatype mappings.The same method could be used for any type of objects.Doing the same from Oracle to SQL Server a pain in the arse..
Good luck...
Subject
Views
Written By
Posted
9661
November 23, 2010 04:30AM
5295
January 28, 2011 03:06AM
4222
June 15, 2011 12:10AM
4261
July 22, 2011 09:37AM
3880
November 10, 2011 01:52AM
how to convert oracle to mysql
4375
August 30, 2011 11:36PM
4120
February 12, 2011 11:11AM
3888
March 16, 2011 12:44PM
4050
April 12, 2011 01:27AM
3993
June 01, 2011 01:59AM
3023
March 05, 2012 02:49PM
2863
April 27, 2012 01:00AM
3269
August 23, 2011 03:27AM
3033
June 04, 2012 05:07AM
8252
June 05, 2012 03:44AM
4461
June 30, 2012 10:02PM
2438
August 21, 2012 03:53AM
3821
August 05, 2011 10:32AM
3346
December 02, 2011 10:28AM
2974
January 06, 2012 09:37AM
3043
February 03, 2012 08:37AM
2711
August 30, 2012 07:20AM
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.