Home
Topics
Enterprise Linux applications and databases
Open source databases
Easy way to move Oracle data nightly to MySQL

Ask the Expert

Easy way to move Oracle data nightly to MySQL

Is there a quick and easy way to move Oracle 8i or 9i data nightly to a similar MySQL schema on a separate server? Most tables are less than 10,000 rows, and the servers are robust, but a few tables have more than one million rows, and a net-change process would be preferred.

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

Well for many situations the ideal solution is to create your own migration script/application and run it nightly. That being said, most of the GUI tools support moving data, you may wish to look at applications like SQLyog and Navicat for their offerings, as both can run scheduled data transfers.

For More Information

Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
The Best MySQL Web Links: tips, tutorials, scripts, and more.
Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

More News and Tutorials

Articles

This was first published in May 2004

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Center
Server Virtualization
Cloud computing
Enterprise Desktop

Data Center
- Red Hat Open Hybrid Cloud aids private, public cloud management
  
  Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.
- Mainframe modernization takes on urgency
  
  A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.
- AMD microprocessors regroup to fight another day
  
  Intel may win the server war, but AMD microprocessors could find more acceptance in another niche market.
Server Virtualization
- Moving VMs around? Avoid downtime with Hyper-V Live Storage Migration
  
  Live Storage Migration eliminates the downtime associated with moving VM files from one storage location to another and helps improve performance.
- RHEV proves to be a cost-effective alternative to vSphere
  
  Some IT departments have turned to low-cost, flexible virtualization platforms, such as Red Hat Enterprise Virtualization, to lower VMware costs.
- Guidelines for moving multiple VMs with Hyper-V Live Storage Migration
  
  Live Storage Migration makes it easy to move multiple storage files of running VMs without downtime, but there are practical limits you should know.
Cloud computing
- IBM, Salesforce deals usher in cloud consolidation era
  
  IBM's SoftLayer buy is getting mixed reviews from IT pros, but everyone agrees that it's an example of the consolidation phase of the cloud bubble.
- U.S. defense agencies' cloud transition yields better intelligence
  
  A cloud migration seems daunting but the effort is worthwhile; U.S. defense agencies say their cloud move led to better military intelligence.
- Simple tricks to lower your AWS cloud costs
  
  There are a number of ways to lower AWS costs and improve the Amazon cloud experience. Here are a few cost-cutting tips any AWS cloud shop can use.
Enterprise Desktop
- Q&A: Microsoft's Erwin Visser discloses Windows 8 mobile strategy
  
  Microsoft GM Erwin Visser discusses the company's mobile strategy for Windows 8 and the need to deliver one device supporting all types of computing.
- Q&A: Microsoft's Erwin Visser on Windows 8.1 updates, security
  
  Microsoft's Erwin Visser discusses Windows 8.1 features, how IT can keep pace with faster update cycles and Windows security enhancements.
- Telerik updates Windows 8 app development tools
  
  Telerik's updated DevCraft tool for developing Windows 8 apps helps IT to deliver business apps to end users on PCs and tablets.

All Rights Reserved,Copyright 2003 - 2013, TechTarget