Msg#: 4513177 posted 11:34 am on Oct 28, 2012 (gmt 0)
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 :)
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.