Delilah, if what you want to move is data only (no code, no triggers)
then you should consider extracting the data into XML or text, then
using oracleXML or SQLLoader to insert it into oracle.

The main advantage to this approach is cost. If you have oracle (at
least version 9.2.0.4) you have nothing else to buy. There is also a
chance you'll benefit from the flexibility these tools offer, but
remember flexibility means more complexity, more time to implement, and
more risk.

You may wish to consider other alternatives if any of these conditions
are true:
- you don't know what table structures in SQL server and have no way to
find that information.
- there are lots of tables (will take time to do each individually) or
there is simply a lot of data
- there isn't enough workspace to hold the XML/text files
- you don't have time to learn how to use oracleXML (part of the XML
Developer's kit - get it from technet.oracle.com if you dont have it
already) or SQLLoader (it's documented in the Database Utilities
Manual).

HTH
Cliff

On Wed, 2005-11-02 at 15:32 +0530, Delilah wrote:
> Hi All,
>
> I need to migrate data from SQL server to Oracle database, tried using DTS but doesn't work it gives the following error message :
> "Error during initialization of the provider"
>
> Is there any other utility to perform this task, please let me know its urgent.
>
> Kind regards,
>
> Delilah Saldanha
>
> ------------------
> Writer Corporation
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page