Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40

    Question Unanswered: Export SQL Server Database to Oracle

    Hi there,
    I have a problem of exporting the SQL Server 2000 database to Oracle 8i. Can anyone help regarding this??
    Please help....
    Thanking you in anticipation
    RGDS
    Amit

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    have done this from oracle8 --> sql 2000, and wasnt bad at all.

    Your main concern will be with the datatype mappings - look for mappings of oracle datatypes to sql...
    DTS should map fairly accurately though - but particular ones need special attention ... (i recall birthdates not coming across at all)
    (I have only done oracle to sql, not the other way around)

    Assuming you have triggers/procs etc. you are going to need to go through your code quite thoroughly to transalte it into working pl/sql.,..
    oracle is a lot more object oriented than transact sql...prob easiest if you condense it into fairly ansi standard sql first if possible, as both (sql/oracle) have unique special features...

    good luck
    des

  3. #3
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40
    hi des,
    Thanks a lot. Through DTS it worked but DTS is not able to convert the stred procedures and triggers etc. It only converts the Tables and views.
    can u help in converting stored procedures as we have almost 30-40 stored procedures and it is rather difficult and time consuming job to recreate and rewrite all the procedures in oracle.
    Thanking u in anticipation.
    RGDS
    Amit

  4. #4
    Join Date
    Feb 2004
    Posts
    107
    Dear Amit,

    You can find some tools like www.swissql.com, www.ispirer.com, etc.
    to convert the sprocs, triggers. Hope this is helpful.

    All The Best!
    Jake

    Originally posted by amitkanodia
    hi des,
    Thanks a lot. Through DTS it worked but DTS is not able to convert the stred procedures and triggers etc. It only converts the Tables and views.
    can u help in converting stored procedures as we have almost 30-40 stored procedures and it is rather difficult and time consuming job to recreate and rewrite all the procedures in oracle.
    Thanking u in anticipation.
    RGDS
    Amit

Posting Permissions

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