Welcome to WebmasterWorld Guest from 54.196.75.226

Forum Moderators: open

Message Too Old, No Replies

Oracle -> MariaDB move

Moving Oracle database to MariaDB, using binary dump

     
11:34 am on Oct 28, 2012 (gmt 0)

New User

5+ Year Member

joined:Feb 13, 2011
posts: 8
votes: 0


Hi,

I'm planning a test to move a database of approx.1 million records from an Oracle XE 10.1 server to a MariaDB server on Debian 6.

I myself have no experience with Oracle, since for many years I'm a MariaDB kinda guy (used to be MySQL). I've managed to install an Oracle XE some time ago, just to see how it is done, but no more than that.

The Oracle admin sent me a 150 Mb binary dump (.dmp) which includes all SQL CREATE statements and I have been told that it ought to work fairly easily.

However, I have so far not found any guidelines how to go about this.

Anyone got a short tutorial for me? Would be much appreciated :)
3:06 pm on Oct 30, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
posts:3416
votes: 0


If you are taking a dump of SQL commands then it should "just work" as long as the commands don't use any proprietary statements from the previous database system. Odds are, those would be in the CREATE TABLE blocks, not in the INSERT blocks.

So, for a fast test, just run all the CREATE TABLE statements and see how it goes! :) Just do it in a new database that won't interfere with any existing tables or data on your test machine.