Re: Import SQL database
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 19 Oct 2003 15:38:02 -0700
Message-ID: <1066516693.661679_at_yasure>
Date: Sun, 19 Oct 2003 15:38:02 -0700
Message-ID: <1066516693.661679_at_yasure>
Mark Goldin wrote:
>How can I import SQL 2000 database into an Oracle database?
>
>Thanks
>
>
>
Depends on what you mean by the word "database."
If you mean the SQL Server definition of the word the Oracle equivalent
is a schema. And then the question
becomes are you talking about recreating the objects (tables, views),
the code (procedures, functions, triggers),
the data itself ...or some combination of the above. And we would need
to know the Oracle version and edition
to be truly helpful.
Also please include the number of objects, the number of records, and the volume in MB or GB.
-- 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 Mon Oct 20 2003 - 00:38:02 CEST
