Chapter 15 DBMS-Specific Features

Reverse Engineering a MS Access 97 Database

PowerDesigner and MS Access 97 use .DAT files to exchange information. These files are reversed into the PDM. The access.mdb database uses or creates .DAT files to reverse Access databases.

You can define the database reverse parameters from the access.mdb database window.

Steps To reverse engineer a MS Access database into a PowerDesigner PDM:

  1. Double-click access.mdb in the PowerDesigner \tools directory.
  2. Select Reverse engineer Access database to Script.
  3. Type the Access database name in the Select Database box.
  4. Type the .DAT file to create in the PowerDesigner File.
  5. Click on the Create button.
  6. In PowerDesigner, select DBMS→Reverse Engineer→Database.
  7. Select the newly generated script file to reverse.
  8. Click OK.

 

Copyright (C) 2006. Sybase Inc. All rights reserved.