Book a Demo

Author Topic: Database Reverse Engineering/Refreshing  (Read 2812 times)

GGoodwin

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Database Reverse Engineering/Refreshing
« on: October 26, 2004, 01:43:01 am »
I have successfully reverse engineered an Access 2000 database and positioned the tables on the Data Model so that they are much more presentable and legible. I have also 'refreshed' the model from the original database source by reusing the 'Import DDL Schema from ODBC' option. The problem is that my nicely laid out tables become all rearranged in the top left hand corner of the model during this 'refresh' process.  Is there a way to 'lock' the position of each table to prevent them being moved during the 'refresh' process?

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: Database Reverse Engineering/Refreshing
« Reply #1 on: October 26, 2004, 03:41:16 pm »
On the Generation page of the Local Options dialog (menu "Tools / Options") there is a list box "Auto Layout diagram on Import". If you set this to either "On New Diagram" or "Never", you should be safe.

HTH
The Sparx Team
[email protected]

GGoodwin

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Database Reverse Engineering/Refreshing
« Reply #2 on: October 26, 2004, 10:56:01 pm »
KP

It works a treat. Thanks for your prompt reply.