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

Thanks, DM!

Alex Ivascu

"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3CC03C49.3376CD55_at_exesolutions.com...
> 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 Sat Apr 20 2002 - 00:26:44 CDT