Even if the scripts use standard SQL commands, you may need to do some editing. The
syntax of many of the Oracle SQL commands is kind of funky. Even MS SQL Server uses a
more standard SQL syntax than Oracle.
-----Original Message-----
From: "Jose Orlando T. Ribeiro" <[EMAIL PROTECTED]>
To: Expert Linux <[EMAIL PROTECTED]>
Date: Tue, 23 Oct 2001 14:40:20 -0200
Subject: [expert] Importing Oracle SQL scripts into MySQL
Hello!
I need some help/advice regarding databases. At college we are using Oracle 8i
as server for our DB lab classes. The teacher give us some exercises, that I can
only do at classes, since I don't have Oracle at home. I tried the Oracle 8i
personal edition. Horrible... 600M of disk space, slow... I´m trying now MySQL
that is already working.
The problem is: to do the exercices at home, I need a demo DB that comes with
Oracle (a script named something like BDEDEMO.SQL), but I can't import that
script to MySQL, seems that the clauses are a little different and since I don't
have any expertise with DB I don't know what to do.
Does anybody knows some tool to import/transform an Oracle dump script into a
MySQL dump script???
TIA
orlando
--
,~~v~~, ,~~v~~,
,'. .', ,'. .',
=== + === === + ===
/ ~ \ / ~ \
/\_m m_/\ /\_m m_/\
.\ +----------------------+ /.
/ ! [EMAIL PROTECTED] ! \
/ +----------------------+ \
`\m/ \m/' `\m/ \m/'
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
