homepage Welcome to WebmasterWorld Guest from 54.198.25.229
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Oracle -> MariaDB move
Moving Oracle database to MariaDB, using binary dump
davurs



 
Msg#: 4513177 posted 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 :)

 

whoisgregg

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



 
Msg#: 4513177 posted 3:06 pm on Oct 30, 2012 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved