Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    38

    Unanswered: How to build a datamodel

    Hi all,in

    I have the database but there is no datamodel, so using the database I have to build one. Can any one help me out in how to do this please? I have the DDL but not knowing from where to start.

    Thanks to you all in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    u have teh ddl?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2007
    Posts
    38
    Yes we have the DDL, now as we are migrating to Oracle from DB2 they need the datamodel, not knowing how to do the reverse engineering can anyone help me out please

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    take the ddl, run it into an empty database to create the tables, then use a data modelling tool to do the reverse engineer

    there are lots to choose from here: http://databaseanswers.org/modelling_tools.htm
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    microsoft visio
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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