Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8

    Exclamation Unanswered: How to Translate an Oracle DataBase to SQL Server DataBase with constraints and views

    Hello,

    Mr. rnealejr:
    I use MS SQL Server 2000.
    Also, I have a problem with SQL Server.
    I have about 50 tables and views in an Oracle DataBase and I have tried to translate them to SQL Server DataBases.
    They were translated succefully but there was two problems :
    1- Key constraints were not translated? (i.e. the destination SQL Server database became without primary key and foreign key constraints and aother constraints)
    2- Also, views are translated into tables not into view ??

    Could you slove these problems?

    After I get more information I will be able to serve your good forum with good posts becuase until now I am student

    Thank you very much

    Shihab

  2. #2
    Join Date
    Apr 2002
    Posts
    56
    Maybe you can 'reverse engineer' the Oracle database with a data modelling tool (e.g. ERwin) and then 'forward engineer' that schema to SQL Server.
    I don't know whether views also can go through this trajectory, but since the syntax of creating views is the same (although SQL Server 2000 doesn't do the create or replace trick) you can build these views from the statements you can see within the Oracle Enterprise Manager or TOAD. Save the creation statements of both the tables, constraints and views in a script. You'll always need it at least once.

    Edwin

  3. #3
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8

    Lightbulb

    Originally posted by edwin
    Maybe you can 'reverse engineer' the Oracle database with a data modelling tool (e.g. ERwin) and then 'forward engineer' that schema to SQL Server.
    I don't know whether views also can go through this trajectory, but since the syntax of creating views is the same (although SQL Server 2000 doesn't do the create or replace trick) you can build these views from the statements you can see within the Oracle Enterprise Manager or TOAD. Save the creation statements of both the tables, constraints and views in a script. You'll always need it at least once.

    Edwin
    I am very sorry, I don't understand what you mean by 'reverse engineer' and 'forward engineer'
    Could you clearify these terms ??
    Thank you very much

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

Posting Permissions

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