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

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 Thu Apr 18 2002 - 20:11:45 CDT