homepage Welcome to WebmasterWorld Guest from 54.227.5.234
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

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




msg:4513179
 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




msg:4513821
 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved