Getting data from Oracle to Mysql
Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting data from Oracle to Mysql
Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting data from Oracle to Mysql
I was thinking we could use copy-db utility. Can anybody tell me if that is a possibility and if there are any known issues. Thanks -Original Message- From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:27 PM To: Kishore Balasubramanya; [EMAIL PROTECTED] Subject: Re: Getting data from Oracle to Mysql Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting data from Oracle to Mysql
What is copy-db utility? Where can I find it? Does it come with MySQL or any other DB? Tell me and I will make use of it, and let you know if there are issues. Today I have 4 dbbases (LDAP, Oracle, SQL Server and MySQL) and I have to keep them with the closest table structure as possible. This means that I have the same tables in all of them. They differ in datatypes (required by the products) but the data is the same for all. Today I have been working with scripts for all relational dbs (it works fine and gives you the whole control of what you are doing). However I would love to try something else. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: Siomara Pantarotto [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 12:29:54 -0400 I was thinking we could use copy-db utility. Can anybody tell me if that is a possibility and if there are any known issues. Thanks -Original Message- From: Siomara Pantarotto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:27 PM To: Kishore Balasubramanya; [EMAIL PROTECTED] Subject: Re: Getting data from Oracle to Mysql Since I know Oracle, MySQL, and Java the fastest way I did it was: 1) I created scripts for creating the tables in both DBs (this is the way I usually do). They differ a bit on datatypes, and I had to remove all the foreign key when dealing with MYSQL. I have 2 scripts called makeOraDB.sql and makeMySQLDB.sql that will call others scripts and generate the dbs in both environments any time I run them. If I need to update or fix the schemas all I need to do is run the scripts again. 2) I created a class in java to deal with the migration and persistence. This class creates 2 connections one with Oracle and another with MySQL. I read the rows in Oracle into a resultset and then I navigate this result set and for every row I do an insert in the MySQL DB. Notice that this is a one shot process. The MySQL tables are completely empty in the beginning of this process. Notice also that the scripts for generating the DB are used in a development environment. In production it would make no sense dropping and generating the DBs again and again. I am in a development process. If you are in a production environment, with your Oracle DB completely populated with data, you can just work on the MYSQL scripts and the java migration class. In summary: I did everything from scratch, completeluy manually. No tools involved. If someone know a better way please let me know. Siomara From: Kishore Balasubramanya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Getting data from Oracle to Mysql Date: Wed, 19 Sep 2001 11:50:27 -0400 Hi, Can anybody tell me how to get all the data and the table structures from Oracle to Mysql. Thanks, Kishore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php