database migration using DTS help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vinod
    New Member
    • Aug 2006
    • 40

    database migration using DTS help

    dear experts, i heard recently, that using DTS, we can convert databases from sql server to oracle. if so, please provide me the process and steps to follow.



    thank you very much
  • aramki
    New Member
    • Sep 2006
    • 9

    #2
    You should just be able to use DTS to move the tables and data from SQL Server to Oracle. DTS can make OLE DB connections to any database that supports OLE DB.

    Hint: you can use the DTS Wizards in the tools menu of the Enterprise manager.

    Comment

    • Prarthana Choudhary
      New Member
      • Aug 2006
      • 7

      #3
      hi,
      you can proceed in this way

      Goto...
      Action -> All Task ->Export Data

      then as per your requirement .............yo u can proceed.

      if you require more quidelines
      plz feel free..

      Comment

      Working...