Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    1

    Unanswered: Reverse enginnering in VISIO 2002 (problem with sp_primarykey)

    I have problem if I want to do reverse engineering in VISIO 2002.
    The database uses primary key created with sp_primarykey an foreign keys with sp_foreingnkey

    In VISIO - Database - Options - Drivers I had set the DDL script generationas follows:
    Preffered version - 6.0
    Generate primary key using - sp_primarykey
    Generate foregin key using - sp_foreignkey

    The process had passed without errors, but the relations didn't showed.
    I tried option "Show related tables" but nothing didn't happend.

    thanks.

  2. #2
    Join Date
    Nov 2001
    Posts
    36
    That could possibily be because of the loss of dependensies. The happens when you drop and recreate few objects in the database, which does ot re-establish the dependensies.

    Try recompiling the objects or establishing the foreign keys again.

    Thanks.

Posting Permissions

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