Re: Importing sql server 7/2000 database to Oracle

[Quoted] Thanks, Daniel. Yes, that is what I want. Now about the autonumbering columns: as long as we aren't going to add to the database and expect autonumbering, I can still have that column, right? That's what it sounds like.

thanks again.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077639180.433784_at_yasure...
> 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)
>
Received on Tue Feb 24 2004 - 17:59:36 CET