Re: migrating MS SQL Server database schema to Oracle 9i

Keep in mind that NCHAR and NVARCHAR exist in Oracle but are different from CHAR and VARCHAR2. And in Oracle you likely will not want to use CHAR for anything so those probably should be converted to VARCHAR2 too.

Also ... do not use LONG or LONG RAW as they are being dropped. Instead use CLOB and BLOB.

Check out this web page:
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/a88876/adg10pck.htm#19357

once you are there ... search for "Datatypes".

Daniel Morgan

Alex Ivascu wrote:

> First create the schema owner (username) in Oracle. Give it the necessary
> permissions. Next, in SQL 2000 Enterprise manager (that's what I used), go
> and Right-Click on a database - select All Tasks - Generate Script - and
> give it a path where to save the output. Default is the screen. After
> you've accomplished that, take out all the [ ], and Collate..., change INT
> to INTEGER and BIGINT to NUMBER, nvarchar(??) to VARCHAR2(??), ntext to LONG
> or VARCHAR2(4000), nchar to CHAR, etc.... and run the script against the
> Oracle Database, as the user/schema owner created in the first step. There
> are quite a few other things that you'll realize along the way. So really,
> there isn't a straight forward way -- because, obviously, everyone's needs
> are different.
>
> I had to go through this a couple of time (migrating from SQL Server to
> Oracle), and it's not that difficult after a while...
>
> Good luck to you, and keep us posted.
>
> Alex Ivascu
>
> "mitra fatolahi" <mitra928_at_hotmail.com> wrote in message
> news:4022442f.0204181454.1cea478f_at_posting.google.com...
> > Hello Everyone,
> >
> > How can i create my MS SQL Server 7 database schema in Oracle 9i
> > database? In other words, how can i migrate MS SQL Server 7 database
> > structure to Oracle 9i? I know that i can generate the database schema
> > script using MS SQL Server 7 Enterprise Manager but i am not sure how
> > and if i can use it to create the same database structure in Oracle
> > 9i.
> >
> > Any help would be greatly appreciated!
> >
> > Thanks,
> > Mitra
Received on Fri Apr 19 2002 - 10:48:35 CDT