Chapter 14 Reverse Engineering a Database into a PDM

Reverse engineering a Microsoft 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 an MS Access database into a PowerDesigner PDM:

  1. Double-click ACCESS.MDB in the PowerDesigner \tools directory.
  2. Select Reverse Engineer Access Database File to PowerDesigner 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 the Create button.
  6. Select DBMS→Reverse Engineering Databases in PowerDesigner.
  7. Select the newly generated script file to reverse.
  8. Click OK.

 

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