"Christian Schäffler" <christian.schaeffler@messring.de> wrote in message
news:eE%23wNIhCFHA.3436@TK2MSFTNGP12.phx.gbl...
> 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
>
>

"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:%23k3otahCFHA.208@TK2MSFTNGP12.phx.gbl...
> 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@messring.de> wrote in message
> news:eE%23wNIhCFHA.3436@TK2MSFTNGP12.phx.gbl...
>> 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
>>
>>
>
>