Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MSSQL to Oracle 9i - conversion
<clayfix98_at_yahoo.com> wrote in message
news:f04d8b06.0404281323.24a5dd0_at_posting.google.com...
> 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
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
Received on Wed Apr 28 2004 - 21:30:45 CDT