DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle to SQL server

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    One of our project (located in one tablespace) has to move from Oracle database to Sql server. Has anybody had this kind of experience?

    Thanks!

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I have not had an experience from oracle database to sql server but I have done migration using oracle migration workbench from sql server 7.0 to oracle 8i database similarly Iam sure microsoft will have there own product for migration from oracle to sql server allmost all RDBMS Vendors do have there own product for migration try at Microsoft Site Iam surely you will come across some product

    Regards
    Santosh

  3. #3
    Join Date
    Apr 2001
    Posts
    42
    Actually SQL Server has a wizard called Data Transformation Services or DTS, this tool lets you pull information for an Oracle database directly into the SQL Server database. It is a pretty straight forward tool that does most of the work for you.
    Utep

  4. #4
    Join Date
    May 2001
    Posts
    70
    Hi Lgaorcl,

    As mentioned you can use the DTS, this will work as long as you have the compatible field types(ie VARCHAR). If you have BLOBS you could have issues, although I belive in SQL Server 2000 you have TEXT fields. I have done LONG to TEXT.

    Depending on the amount of data being processed DTS could take a very long time. I have seen the DTS take an hour to move only 250 Megs of Data.

    You will have to evaluate closely your stored procedures, triggers and constraints. They don't migrate nicely.

    Good Luck.

  5. #5
    Join Date
    Jun 2000
    Posts
    315
    Hi, guys:

    Thanks! Could you tell me where to get data transformation services?

    Lisa

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