Moving data from Oracle to SQL server and vice versa


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Moving data from Oracle to SQL server and vice versa

  1. #1
    Nivedita Guest

    Moving data from Oracle to SQL server and vice versa


    Hi

    I need to write an application which moves data from one database to another
    especially from oracle to SQL and vice versa
    Please let me know some tools which do this and a link to the technical articles
    Thanks
    Nivedita

  2. #2
    sathishkumar Guest

    Re: Moving data from Oracle to SQL server and vice versa


    hi,

    You can create a package for this using sqlserver2000( may be sqlserver7.0
    also). This can be done using DTS(Data transformation) tool in enterprise
    manager of sqlserver. This tools opens a GUI which helps you to create a
    package( self explanative). finally you can run this package or it can create
    VisualBasic code for you. for more help refer msdn or sqlserver books online.

    With regards,
    V.Sathishkumar

    "Nivedita" <nivedita@india.hp.com> wrote:
    >
    >Hi
    >
    >I need to write an application which moves data from one database to another
    >especially from oracle to SQL and vice versa
    >Please let me know some tools which do this and a link to the technical

    articles
    >Thanks
    >Nivedita



  3. #3
    Alex Guest

    Re: Moving data from Oracle to SQL server and vice versa


    "Nivedita" <nivedita@india.hp.com> wrote:
    >
    >Hi
    >
    >I need to write an application which moves data from one database to another
    >especially from oracle to SQL and vice versa
    >Please let me know some tools which do this and a link to the technical

    articles
    >Thanks
    >Nivedita


    You can post code in the Oracle Database trougth PLSQL, and send flat files
    to SQL Server, and received from SQL-Server flat files, too. You can use
    the PLSQL command UTL_FILE. In Sql-Server you use bcp commands to load the
    flat files ...




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center