Database Migration [ Oracle to MySQL ]
#~~#Action Plan for Database Migration with best practices:
1.Prepare to Migrate
2.Test the Migration Process
3.Test the Migrated Test Database
4.Prepare and Preserve the Source Database
5.Migrate the Production Database
6.Tune and Adjust the New Production Database
#~~#Database Migration:
-1-Schema Migration Action Plan from Oracle to MySQL:
Migrate oracle schema into MySQL either manually or you can also use software for schema http://www.convert-in.com/ora2sql.htm but here if using third party utility then please make sure it migrated into optimal state.This one is the most important step in migration and should be properly verified in order to avoid any unnecessary service outage in future.
There are also some third party tools that can help in complete migration,Here we have shared plan for doing manual migration freely without any cost.
Tools are :
i) Oracle-to-MySQL
link:- http://dbconvert.com/convert-oracle-to-mysql-pro.php
ii) SQLways - Oracle to MySQL data migration
link:- http://www.ispirer.com/products/oracle-to-mysql-migration
any many more third party utitiles are there.
Note:There is one blog that I have found later after migration but i would like to list it here for your help its link is http://tkurek.blogspot.in/2013/04/migrate-oracle-to-mysql.html
Imp.Note:Will soon upload datatype & functioanlity comparision for Oracle and MySQL.
-2-Procedure/Function/Triggers Migration Action Plan from Oracle to MySQL:
It includes cnversion of follwing action items
i).Syntax conversion.
ii).Conversion for Oracle built-in functionality into MySQL built-in functionality if available else create user defined funtionality for the same behaviour.
iii).User Defined Method Conversion.
-3-Data Migration Action Plan from Oracle to MySQL:
a). Take dump from oracle using below listed format into dumpfiles
SET TRIMSPOOL ON
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
Spool /path/filename.csv
query(i.e select Col1||','||','||Col2||','||Col3 from tablename; Note:Please make sure the output format of column in query should be as per MySQL format)
quit
b). Restore dumpfiles into MySQL using load command or mysql import utilities for dumpfile that we get from step 2.
#~~#Action Plan for Database Migration with best practices:
1.Prepare to Migrate
2.Test the Migration Process
3.Test the Migrated Test Database
4.Prepare and Preserve the Source Database
5.Migrate the Production Database
6.Tune and Adjust the New Production Database
#~~#Database Migration:
-1-Schema Migration Action Plan from Oracle to MySQL:
Migrate oracle schema into MySQL either manually or you can also use software for schema http://www.convert-in.com/ora2sql.htm but here if using third party utility then please make sure it migrated into optimal state.This one is the most important step in migration and should be properly verified in order to avoid any unnecessary service outage in future.
There are also some third party tools that can help in complete migration,Here we have shared plan for doing manual migration freely without any cost.
Tools are :
i) Oracle-to-MySQL
link:- http://dbconvert.com/convert-oracle-to-mysql-pro.php
ii) SQLways - Oracle to MySQL data migration
link:- http://www.ispirer.com/products/oracle-to-mysql-migration
any many more third party utitiles are there.
Note:There is one blog that I have found later after migration but i would like to list it here for your help its link is http://tkurek.blogspot.in/2013/04/migrate-oracle-to-mysql.html
Imp.Note:Will soon upload datatype & functioanlity comparision for Oracle and MySQL.
-2-Procedure/Function/Triggers Migration Action Plan from Oracle to MySQL:
It includes cnversion of follwing action items
i).Syntax conversion.
ii).Conversion for Oracle built-in functionality into MySQL built-in functionality if available else create user defined funtionality for the same behaviour.
iii).User Defined Method Conversion.
-3-Data Migration Action Plan from Oracle to MySQL:
a). Take dump from oracle using below listed format into dumpfiles
SET TRIMSPOOL ON
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
Spool /path/filename.csv
query(i.e select Col1||','||','||Col2||','||Col3 from tablename; Note:Please make sure the output format of column in query should be as per MySQL format)
quit
b). Restore dumpfiles into MySQL using load command or mysql import utilities for dumpfile that we get from step 2.
No comments:
Post a Comment