Re: SQL Server tables to Oracle


"aman.oracle.dba" <aman.oracle.dba@xxxxxxxxx> wrote in message
news:1154276611.924501.12530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Please inform can I transfer sql server tables to Oracle, without using
sql loader and external table concept.
How................


You can use DTS packages from within SQL Server. The only thing you need to
do is install the Oracle client libraries on the SQL Server box and define a
connection to the Oracle instance.


.

Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000 DTS Designer Components
    ... I actually have not installed the DTS Designer on the servers directly, but install it on client machines of programmers and administrators who manage the DTS packages. ... Having said that, I see that on my 64-bit server installation, the SQL Server Management Studio 2005, etc. are all x86 programs so the DTS Designer should work even there. ...
    (microsoft.public.sqlserver.clients)
  • Re: Importing data from ORACLE.
    ... You can get the Oracle client drivers from the Oracle site or your Admin ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... Do I need to install any thing on>> the machine hosting SQL Server? ...
    (microsoft.public.sqlserver.dts)
  • Re: Transform Data Task - properties gives error
    ... and it turns out the oracle client ... I had a person on site install the oracle client and ... I touch DTS - it's awesome. ... >www.allisonmitchell.com - Expert SQL Server Consultancy. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server tables to Oracle
    ... You can use DTS packages from within SQL Server. ... The only thing you need to do is install the Oracle client libraries on the SQL Server box and define a connection to the Oracle instance. ...
    (comp.databases.oracle.server)