Move large data from SQLserver to ORACLE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Move large data from SQLserver to ORACLE

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello DBAs :

    Our environment :
    Siebel Application
    Dev on SQL Server/NT (about 35GB)
    Test (Pre prod) and Prod in Oracle/IBM Aix
    DTS Tool (to transfer data)

    We shall be doing some data transformations between SQL server and into Oracle about 35GB. I would like to prepare myself with an environment to suit this kind of data load. Can any of you please give any pointers to where all, I should be careful or Points of failures happen. eg., RBS, Datafiles (how many to allocate, size limitations, extensibility etc., and what is the best configuaration and SGA allocation and so on.

    Please let me know for any specific Qns on my environment and I can post it here.

    Thanks, ST

    ~

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    For Transferring large data from Sql Server to Oracle I feel the product you can use is

    Oracle Transparent gateway for Sql Server

    It is easy to Install and set it up also here is a link for the same

    http://otn.oracle.com/docs/products/...sql_nt/toc.htm

    For Transferring large data from Oracle to Sql serever I think you can use DTS

    Regards
    Santosh

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Hello Santoshym :

    We have already decided on using DTS and have spent more than 2 months on DTS already developing the DTS.. I did mean to ask how DTS works or is it good..

    My concern is strictly on the Oracle side, when the data transfer happens, what are all the precautions I should take and what should I expect and so on, since database has nothing but the schema and Indexes for Siebel user.. How to plan my oracle environment is something that I am looking for. Would appreciate any replies..

    Thanks, ST2K

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width