Re: Oracle's dump to MySQL

From: Date: Thu, 02 Apr 2009 21:47:59 +0000
Subject: Re: Oracle's dump to MySQL
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-290988@lists.php.net to get a copy of this message
9el wrote:
I found this command from one guy for importing Oracle's dump to MySQL Shell> mysql -uroot db_name -vvf < oracle_dump.dmp But, v is for verbose and f is for force continuation. Anyone worked with Oracle and MySQL?
Yep, and there's no way that will ever work except for the very simplest table and data. The datatypes are different (mysql doesn't have varchar2, timestamp formats are different though oracle lets you change that). You'll need to do a schema-only dump, convert it to the mysql format, then worry about converting the data. -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.general (#290988) next »