Re: Importing sql server 7/2000 database to Oracle

E Sullivan wrote:

> Hi,
>
> Is it possible to import a MS sql server 7 or 2000 database into Oracle?
> Also, if this is possible, would it be better to just import tables and no
> stored procedures?
>
> thanks,
>
> Ellie

What do you mean by "import"?

If you mean dump the data as a delimited text file and use SQL*Loader. Yes.

But do keep in mind you will need to translate some data types and autonumbering columns do not exist.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)