Re: data transformation services

As Niall ponted out,

You can still use DTS. DTS is not tied to using SQL server as either a source or a target. Best choice is probably Oracle provider for OLE-DB.

Jon

"Sameer Bhardwaj" <sameer.bhardwaj_at_india.techspan.com> wrote in message news:7ed12dc.0203252222.6395fcb9_at_posting.google.com...
> Hi Niall,
> Thanks for your answer
> currently we have two databases say A and B now what we do is we
> populate the database A from the application and use data
> transformation services of sql server to populate the data in database
> B which is being used as a ware house.Currently both the databases are
> on SQL Server. Now do we have any such facility in Oracle by which we
> can do that
>
> sameer
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3c9eff7a$0$8509$ed9e5944_at_reading.news.pipex.net>...
> > If you are referring to the database server then the answer is no not
> > really. I believe that designer allows you to do similar things, but if
you
> > are in a mixed environment you can always use data transformation
services
> > with an Oracle database as source and destination.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Sameer Bhardwaj" <Sameer.Bhardwaj_at_india.techspan.com> wrote in message
> > news:39d276dc.0203250112.75dc91e6_at_posting.google.com...
> > > Do we have an equivalent of Data Transformation Services of MS-SQL
> > > Server in Oracle ?
Received on Tue Mar 26 2002 - 06:52:52 CST