Results 1 to 4 of 4

Thread: Migrating Oracle Data to SQL SErver

  1. 03-14-2005, 07:50 PM #1
    thinking_olap
    thinking_olap is offline Registered User
    Join Date
    Dec 2004
    Location
    Australia
    Posts
    7

    Migrating Oracle Data to SQL SErver

    Hi Forum,

    I would like to archive all my company's data to an sql server. currently we have all our data stored on a oracle server and going forward we wanna use sql server. I tried using the DTS, but the transfer of data is very very slow. Here i am talking about tables with gigs of data. Could you advise whats the best possible to transfer?
    Reply With Quote Reply With Quote
  2. 03-15-2005, 04:01 AM #2
    TheLoneStar
    TheLoneStar is offline Registered User
    Join Date
    Mar 2005
    Location
    Germany
    Posts
    10
    I've tried SisSQL Conversion tool, which provide excellent results. It also converts procedures and functions such as java packages.
    Reply With Quote Reply With Quote
  3. 03-15-2005, 04:04 AM #3
    thinking_olap
    thinking_olap is offline Registered User
    Join Date
    Dec 2004
    Location
    Australia
    Posts
    7
    THanx buddy. Shall try that tool tomorow.
    Reply With Quote Reply With Quote
  4. 03-15-2005, 11:31 AM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    For large datasets DTS is slow, if you can get data in CSV format (or any other delimited format) then you can use BULK INSERT command to import it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules