I'm attempting to move a database which currently exists on an old Oracle
7.34 instance and tried to use Data Import via DTS to SQL 2000.
The Oracle database consists of views, indexes,packages,triggers as well as
tables structures. I tried DTS using both the ODBC and OLE for Oracle and
only tables and data came over correctly.

Views it appears were converted into tables. Indexes never came acros at
all.

I'm using the Oracle 9.2 client on my workstation.

Any ideas on how I might be able to convert this database over from Oracle?



thks

_ALL_ that will come over is tables and data + views as tables. DTS will
not move the other stuff itself

If you go up onto the MS site they did have some interesting stuff
pertaining to the Oracle guy coming to SQL Server.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Jack Snow" <mrbrew5510 (AT) hotmail (DOT) com> wrote