Welcome to WebmasterWorld Guest from 54.145.173.36

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)



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)

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



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.