How do you import data from an oracle database into a mysql database?

Joseph K asks:

Question

3 tables from oracle are to be copied to and merged in mysql. Can it be done manually? Also, is it possible to make a program to transfer the needed data from one database to the other?

Answer

As long as the data is mostly text/int type stuff, the easiest way to transfer data between database types is to dump it to a CSV and import that CSV into the new database. CSV notation is fairly standard and usually work across the major db's nicely.

Related Products

High Performance Oracle Data Warehousing: All You Need to Master Professional Database Development Using Oracle

(more details)
Shows how to implement advanced decision systems without buying specialized products. Includes clear, working example code that has been tested and proven in real-world Oracle data warehouse systems, as well as ready-to-run SQL scripts, optimized tables, forms, templates, and tools for setting up large-scale databases. Demonstrates how to troubleshoot, providing solutions to common data warehousing problems. Explains how to improve performance by optimizing distributed data warehouse systems wit (Amazon.com, none)

ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET: A practical guide for developers ... Developer Tools for Visual Studio 2005

(more details)
A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP.NET Dealing with XML DB using ODP.NET Oracle Developer Tools for Visual Studio .NET In Detail The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment and allows developers to take advantage of advanced Oracle database functionality, including Real Application (Amazon.com, none)

MySQL Database Design and Tuning

(more details)
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable My (Amazon.com, none)

MySQL Database Design and Tuning (Developer's Library)

(more details)
The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to: Deploy the right MySQL product for your performance needs. Set up a performance man (Amazon.com, none)

Access Database Design & Programming (3rd Edition)

(more details)
Author : Condition : New , Publisher : Year : Pages : EAN : ISBN : 0596002734Binding : (miscellaneous, Textbookonly.com)

PHP MySQL Website Programming: Problem - Design - Solution

(more details)
PHP MySQL Website Programming: Problem - Design - Solution shows the development process for a website using a specific set of technologies: the Apache web server, the MySQL database system, and the PHP scripting language. It gives you a completely hands-on experience and guides you through the construction of a complete application-driven site from design to deployment. Each chapter in the book is broken into three parts: Problem: The authors analyze each task and identify areas that may (Amazon.com, none)

PHP MySQL Website Programming: Problem - Design - Solution

(more details)
PHP MySQL Website Programming: Problem - Design - Solution shows the development process for a website using a specific set of technologies: the Apache web server, the MySQL database system, and the PHP scripting language. It gives you a completely hands-on experience and guides you through the construction of a complete application-driven site from design to deployment. Each chapter in the book is broken into three parts: Problem: The authors analyze each task and identify areas that may (Amazon.com, none)

Oracle Database 10g RMAN Backup & Recovery

(more details)
The Most Complete Guide to Maximizing Oracle Recovery ManagerDeploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, g (Amazon.com, none)

Metadata 100 Success Secrets 100 Most asked questions on Meta Data How-To Management, Repositories, Software, Standards, Tools and Databases

(more details)
Metadata (meta data, or sometimes metainformation) is "data about data", of any sort in any media. An item of metadata may describe an individual datum, or content item, or a collection of data including multiple content items and hierarchical levels, for example a database schema. Metadata provides context for data. Metadata is used to facilitate the understanding, characteristics, and management usage of data. The metadata required for effective data management varies with the type of d (Amazon.com, none)

Microsoft Access 2007 Quick Reference Card - Handy Durable Tri-Fold MS Access 2007 Database Tip & Tricks Guide. 6 Total Pages. Stores Easily. Ultimate Reference for Shortcuts, Tips & Cheats for MS Access 2007 data base software. (Software Quick Reference

(more details)
Microsoft Access 2007 Quick Start Card -- Six tri-folded pages of easy-to-understand Access 2007 instructions -- Although Microsoft Access is one of the most intuitive database programs, most end users still need guidance learning to create and edit database design and information. BrainStorm's Microsoft Access 2007 Quick Start Card gives Access users a tangible training reference card that will teach novice to advanced end users how to perform the following new Access functions as well as b (Amazon.com, none)

Web Database Applications With Php and Mysql Book [Used]

(more details)
What do eBay, Amazon.com and CNN.com have in common? They're all applications that integrate large databases with the Web. The popularity (and power) of these applications stems from their accessibility and usability: thousands of users can access the... (Glyde, miscellaneous)

MySQL: Your visual blueprint for creating open source databases

(more details)
* Discusses the basic fundamentals including database terminology and concepts. * Offers an introduction to MySQL and the SQL language, then includes essential tasks to begin using it. * Explores the essentials of MySQL server management, providing a guide for troubleshooting problems. * Presents numerous annotated screenshots, tips and tricks. * Includes a CD-ROM with additional code examples as well as advanced examples using MySQL for UNIX and Windows, PHP for Windows and UNIX, an (Amazon.com, none)

Estimating the degree of similarity overlap for structural data in spectral databases [An article from: Analytica Chimica Acta]

(more details)
This digital document is a journal article from Analytica Chimica Acta, published by Elsevier in . The article is delivered in HTML format and is available in your Amazon.com Media Library immediately after purchase. You can view it with any web browser.Description: A method for the chemical structure overlap of two spectral databases estimating is suggested. The technique matches all compounds from the infrared (IR) spectral database against all compounds from the mass-spectral database using t (Amazon.com, none)

Management of Heterogeneous & Autonomous Database Systems (The Morgan Kaufmann Series in Data Management Systems)

(more details)
"As organizations have become more sophisticated, pressure to provide information sharing across dissimilar platforms has mounted. In addition, advances in distributed computing and networking combined with the affordable high level of connectivity, are making information sharing across databases closer to being accomplished…With the advent of the internet, intranets, and affordable network connectivity, business reengineering has become a necessity for modern corporations to stay competiti (Amazon.com, none)

JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution Approach (Expert's Voice in Java)

(more details)
JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the authors other book, JDBC Recipes: A Problem-Solution Approach, leaves off. This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developers application development (Amazon.com, none)

Oracle Database 11g New Features (Osborne ORACLE Press Series)

(more details)
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11gRealize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presen (Amazon.com, none)

How to Design, Build & Program Your Own Advanced Working Computer System Book [Used]

(more details)
Visible wear to book and dust jacket. Spine may be worn but not broken. May have limited markings or folded pages. May be a former library book. (Glyde, miscellaneous)

The TurnKey Publisher's Audio Publishing Handbook: How to Create & Self-Publish Profitable Audio Books & Audio Programs Without Any Help From Publishers or Recording Studios!

(more details)
"LEARN THE SECRETS OF AUDIO PUBLISHING TRADITIONAL PUBLISHERS HAVE NOT YET DISCOVERED!" For decades, writing and publishing a book has been the traditional path for anyone who wanted the prestige, credibility, and distinction of being an author. The rising popularity of audio books and audio programs have provided unprecedented opportunities to become an author by writing and publishing your own audio books and audio programs. Traditional publishers continue to produce boring audio books by hi (Amazon.com, none)

101 Internet Businesses You Can Start from Home: How to Choose and Build Your Own Successful e-Business (101 Internet Businesses You Can Start from Home: How to Choose &)

(more details)
Written for those who want to break away from rigid schedules, unappreciative bosses, and soul-sapping commutes, this book puts prospective Internet entrepreneurs on the road to success by offering an analysis of Internet mechanics and commerce and providing profiles of successful Internet businesses. Containing more than just technical information, this manual also helps the entrepreneur prioritize business goals and evaluate comfortable levels of risk, ensuring that the chosen business matches (Amazon.com, none)

Are You Financially Checkmate?: You Live in an Economic Culture Designed to Keep You Broke. Discover How to Take Control and Free Yourself From Financial Bondage.

(more details)
Our recent recession has exposed several flaws in our economic system, one of which is our individual financial vulnerability. Millions of Americans are trapped financially, a condition referred to as, FINANCIALLY CHECKMATE! Our individual financial state was not caused by the recession, as some would like you to believe. On the contrary, our personal financial instability is partly responsible for our current economic condition and will continue to be a major concern in the future, unless we c (Amazon.com, none)

Beginning Database Design: From Novice to Professional

(more details)
Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn how to discover and represent the details and scope of the problem in question. Database design is not an exact science, and solid database desi (Amazon.com, none)

Database Application Development & Design w/ERD Drawing Tool

(more details)
To help students gain the skills for application development, database design, and managing databases, Database Application Development and Design adheres to three guiding principles: (1) Combine concepts and practice. The textbook and the accompanying supplements have been designed to provide close integration between concepts and practice. (2) Emphasize problem-solving skills. This book features problem-solving guidelines to help students master the fundamental skills of data modeling, no (Amazon.com, none)

Benchmarking R&D and companies through patent analysis using free databases and special software: a tool to improve innovative thinking [An article from: World Patent Information]

(more details)
This digital document is a journal article from World Patent Information, published by Elsevier in 2004. The article is delivered in HTML format and is available in your Amazon.com Media Library immediately after purchase. You can view it with any web browser.Description: The availability of free patent databases on the Internet, offers the opportunity of opening the door of patent information not only to patent specialists, but also to many other groups, such as researchers, decision makers, po (Amazon.com, none)

PHP and MySQL Manual: Simple, yet Powerful Web Programming (Springer Professional Computing)

(more details)
PHP is becoming the language of choice for Web development, in particular for e-Commerce and on-line database systems. PHP is open source software and easy to install, and with the growth of broadband connections in the home means that more and more people can set up their own personal web servers and create their own on-line applications. Covering all the latest features and functions of PHP including the use of object-oriented programming, this book explains how to use PHP to its full extent. (Amazon.com, none)

Related Articles

Related Questions