| By Jayaram Krishnaswamy | Article Rating: |
|
| January 31, 2010 11:29 AM EST | Reads: |
630 |
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,
Read the original blog entry...
Published January 31, 2010 Reads 630
Copyright © 2010 Ulitzer, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Jayaram Krishnaswamy
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 recent book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. He writes articles on several topics to many sites.
- Cloud Economics – Amazon, Microsoft, Google Compared
- Oracle, Sun and the Enterprise CTO
- So It’s Gonna Drizzle on Rackspace
- EC Antitrust Chief’s Job Ambitions Reportedly Delay Oracle-Sun OK
- Return of the Web Application Platform Wars
- Online Music and Open Source Business Models
- Technology Tiering, Servers Storage and Snow Removal
- Oracle’s Acquisition of Sun: Could They Damage Open Source?
- Migrating a MySQL Table Using Oracle SQL Developer 1.5
- Cloud Expo Sponsor Rackspace Launches Media Services Solution
- Kickfire Announces Entry Into Rackspace Partner Network to Deliver Analytic Appliance Hosting and Managed Services
- The Open Source IT Service Management Solution OTRS::ITSM 2.0 Brings Affordable ITIL-Compatible Change Management to Companies Worldwide
- Now Russia Threatens to Hold Up Oracle-Sun Deal
- Oracle’s Next Sun Hurdle
- Cloud Economics – Amazon, Microsoft, Google Compared
- Is 19 Oracle’s Lucky Number?
- ‘Save MySQL from Oracle’ Petition Collects 13,600+ Signatures So Far
- Oracle-Sun: MySQL Creator Kicks Off Worldwide Petition
- ‘Save MySQL from Oracle’ Petition Delivered to 3 Antitrust Regulators
- Samsung Showcases the Future of Home Entertainment – and Beyond – at CES 2010
- Understanding Cloud Taxonomies and Security
- Oracle, Sun and the Enterprise CTO
- So It’s Gonna Drizzle on Rackspace
- EC Antitrust Chief’s Job Ambitions Reportedly Delay Oracle-Sun OK
- The i-Technology Right Stuff
- Java Feature — Bringing Together Eclipse,WTP, Struts, and Hibernate
- i-Technology Viewpoint: The New Paradigm of IT Buying
- Trail of tears: MySQL, ODBC & OpenOffice 1.0
- Who's Missing From SYS-CON's i-Technology Top Twenty?
- i-Technology Viewpoint: Open Wounds – How Free May End Up Being Costly
- Web and Mobile Convergence Sharing Data Between Flex 2 and Flash Lite
- Building a Forum with Macromedia Dreamweaver From Adobe
- Making MySQL, ODBC & OpenOffice 1.0 work together, Part 2
- How to install Nola, the free accounting package for Linux
- Is Java a "Ball and Chain"?
- Guest Editorial by Kim Polese: "From Here to Ubiquity"






























Ulitzer content is offered under Creative Commons "Attribution Non-Commercial No Derivatives" License.
For any reuse or distribution, you must make clear to others the license terms of this work.
The best way to do this is with a link to this web page.
Any of the above conditions can be waived if you get written permission from Ulitzer, Inc., the copyright holder.
Nothing in this license impairs or restricts the author's moral rights.