SQL Server Database Design in ERWIN 4.0

  • I am making an ERD by using ERWin 4.0. Current I am facing a problem while defining Foreign key. In the PArent I am having a Primary Key. I want to define the Foreign Key twice in the Child Table. EVen though I am eble to do it throu the Database Design using SQL server. But the same I am unable to do it through ERWIn. But bay using BAckward Engg of ERWIn I am able to get the correct figure.

    Can anybody help me out.

    TapKs


    TapKs

  • I've got Erwin and the same thing occurs. IMHO, Erwin 4.0 isn't a great product, especially for a 4.0 product. No NT Auth, cumbersome design.

    I tend to do things in SQL and reverse engineer them for docs.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • I design DBs in SQL and use Reverse Eng. in VISIO for docs. I have both VISIO and ERwin; I perfer VISIO.

  • Try Embarcadero's ER Studio - brilliant tool

    Greg M Lucas
    "Your mind is like a parachute, it has to be open to work" - Frank Zappa

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply