Hi folks,

right now I'm planning to migrate a complete Oracle database (Oracle is
V9.2.0.5 running on a Microsoft Server) to a SQL 2000 Server.
Now the question is, wether DTS is the right tool to do this or not. This is
the first time I'm doing a task like that, so I still try finding the right
method of solution.
Any comments on my topics are appreciated

Best regards,
Christian Schaeffler

DTS is a data transfer tool. So if you plan to manually migrate structures
and code objects then DTS can help, but usually this is not what people
want. Do not expect DTS to perform perfect migrations of table structures. I
would read some of the whitepapers about such migrations (sure MS has one on
www.microsoft.com/sql), and maybe consider a dedicated tool if your
situation justifies it. DTS can help, but only if you tell it exactly what
to do first.



--
Darren Green
http://www.sqldts.com
http://www.sqlis.com



"Christian Schäffler" <christian.schaeffler (AT) messring (DOT) de> wrote

[...]maybe consider a dedicated tool[...]
Can you recommend one?


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote