WarehouseArchitect - User's Guide

PowerDesigner can modify database structure directly. To do so, you must connect to a data source via an ODBC driver.

To modify a database directly:
1. Select Database-->Modify Database.
  The Modification Parameters dialog box appears.
2. Type a destination filename for the script file in the File Name box.
3. Type a destination directory for the script file in the Directory box.
4. If you want to modify a database for objects belonging to a particular owner, select an owner from the Owner dropdown list.
  or
  If you want to modify a database for all objects in the WAM, select All from the Owner dropdown list.
5. Type an archive (APM) filename in the Archived Model box.
6. Select modification parameters.
7. Click the Options tab.
  The Options page appears.
8. Select script options and referential integrity options.
9. Click the Modify Database button.
  A dialog box asks you to identify a data source and connection parameters.
10. Select a data source from the dropdown listbox.
11. Type your user name and password.
12. Click Connect and, if prompted by your data source, enter additional connection parameters.
  A message window shows the progress of the alter process.
13. Click OK.


	Expand Search