| By Jayaram Krishnaswamy |
Article Rating: |
|
| January 31, 2010 11:29 AM EST |
Reads: |
3,240 |
MySQL Journal on Ulitzer
Now that MySQL is joining the Oracle family, migration of MySQL to Oracle will be one of internal transfer. However this article written prior to recent developments describes the migration of MySQL to Oracle.
This article shows how you may use Oracle's most recent tool, the Oracle SQL Developer 1.5 to work with the MySQL database. An example of migrating a table in MySQL to Oracle 10G XE is described.
The Oracle SQL Developer Tool has steadily improved from its beginnings in version 1.1. The earlier versions are briefly explained here. The latest version, SQL Developer 1.5.4 released in March 2009 was described in this article.
The SQL Developer tool[(1.5.4.59.40)] bundle can be downloaded from Oracle's web site, Oracle Technology Products. When you unzip the bundle you are ready to start using this tool. You may get an even more recent version of this tool as it is continuously updated.
It is assumed that you have a MySQL Server that you can connect to and that you have the required credentials. The MySQL server used in developing this article was installed when the XAMPP bundle was installed. Reader will benefit by reading earlier MySQL articles 1,
2, 3 on the Packt site.
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK.
His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham.
Most recently his book, "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc.
He writes articles on several topics to many sites.
Subscribe to Open Source Magazine Email News Alerts
Subscribe via RSS
