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

Thread: Migration to sqlserver

  1. #1
    Join Date
    Mar 2002
    Posts
    303

    Migration to sqlserver

    Hi,

    I have a schema in Oracle DB. I want to migrate this schema tables and stored procedures) to sqlserver. is there any migration tool ?

    Bensmail

  2. #2
    Join Date
    Jan 2001
    Posts
    81
    for schema you can try to reverse engineer in Platinum ERWIN or some DB independent tool and then regenrate for SQL Server,

    but for stored procedures, I think you pretty much stuck with manual
    conversion, but there may be a magic tool somewhere out there....

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    For smaller databases you can use any third party tools like DBartisan etc., For SPs you have to generate scripts ..

    If you can not effort third party . USe SQL server DTS.It is easy and free with SQL ..
    Raghu

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Getting the data ove should be easy. If you have a lot of stored procedures, you will need to recode that and make changes on your front end. Why are you planning on moving to SQL Server?

  5. #5
    Join Date
    Oct 2003
    Posts
    65
    If you want to move to SQL SERVER,Use DTS in SQLSERVER

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Here's a tool you might be interested in:

    It converts PL/SQL to T-SQL

    http://www.swissql.com/oracle-to-sql-server.html

    I agree with the rest of the gang, DTS. Primary keys are handled differently ("IDENTITY" datatype autogenerates an ID, Oracle needs a trigger/sequence)

    Best of luck,
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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