MSSQL to Oracle 9i - conversion

clay...@yahoo.com

unread,

Apr 28, 2004, 5:23:48 PM4/28/04

to

Hi all, I am not very familiar with database but I have a general
question about Database Scripts.

-- We currently have a database script that executes on MSSQL 2000
(Windows). It builds the database for MSSQL 2000 for our application.

Now, we want to take the same exact script and use it for Oracle 9i on
UNIX.

Is there a tool that would convert the database script from MSSQL 2000
to Oracle 9i (UNIX)? It would be great to find a program that would
take my original MSSQL 2000 script and it convert it to the proper
syntax so that Oracle can use it to build the my database. (Does
Oracle have a tool or mode that will read MSSQL 2000 syntax?) Our
database is not very fancy but I notice that SQL syntax for Oracle
looks a lot different than the MSSQL script.

Any recommendations would be greatly appreciated.

--Rookie database person

Bricklen

unread,

Apr 28, 2004, 5:40:04 PM4/28/04

to

clay...@yahoo.com wrote:
<snip>
Try here to begin with:
http://download-west.oracle.com/docs/html/B10254_01/toc.htm

note: you may have to register an account with OTN, but it's free, and
you don't generally get spammed.

Jim Kennedy

unread,

Apr 28, 2004, 10:30:45 PM4/28/04

to

<clay...@yahoo.com> wrote in message
news:f04d8b06.0404...@posting.google.com...

You can use their migration workbench, but I suspect that in Oracle you will
already have a database and create a schema for your tables. You need to
understand that Oracle!=MS Sql Server. You will have to learn a bunch of
concepts that are different than what you already know. In addition, I
would look at the application because you are going to have some nasty
surprises when you connect up; things work differently.
Jim

Hans Forbrich

unread,

Apr 28, 2004, 11:06:39 PM4/28/04

to

clay...@yahoo.com wrote:

> -- We currently have a database script that executes on MSSQL 2000
> (Windows). It builds the database for MSSQL 2000 for our application.
>
> Now, we want to take the same exact script and use it for Oracle 9i on
> UNIX.

To paraphrase others:

SQL is SQL. But DBMSs are not the same and they are allowed to translate
the SQL differently. For perfectly valid reasons, what works well in SQL
Server may not work well in Oracle and what works well in Oracle may not
work well in SQL Server!

PLEASE get yourself a copy of Tom Kyte's book "Expert One-on-one Oracle" and
browse through that. It is filled from one end to the other with examples
of "how a straight port will fail" and "if you want performance, do it this
way".

It is quite possible that using the exact same script will not be to your
advantage.

/Hans

Mladen Gogala

unread,

May 8, 2004, 5:58:58 PM5/8/04

to

On Wed, 28 Apr 2004 14:23:48 -0700, clayfix98 wrote:

> Hi all, I am not very familiar with database but I have a general
> question about Database Scripts.
>
> -- We currently have a database script that executes on MSSQL 2000
> (Windows). It builds the database for MSSQL 2000 for our application.
>
> Now, we want to take the same exact script and use it for Oracle 9i on
> UNIX.

Tere is the tool called "Pathologically Eclectic Rubish Lister" or perl,
for short. You can download it from http://www.perl.com. For Windoze
systems, the distribution is on www.activestate.com. This tool works on
both Micros*t excuse for an operating system and on decent Unix systems.
That is the Only Way (TM) to get the same script working on both systems.

--
Trust me, I know what I'm doing. (Sledge Hammer)

Anna C. Dent

unread,

May 8, 2004, 9:03:17 PM5/8/04

to

Alternatively, load CYGWIN on the PC;
which supports running the same bash scripts on PC & *NIX.