Working with Data Models › Forward Engineering › Generate Alter Scripts

Generate Alter Scripts

The Schema Generation functionality includes the capability to quickly generate alter scripts. When you make changes to your physical model you can synchronize them with your database or script file.

This process describes how you utilize the alter scripts functionality:

• In your changed model, click Forward Engineer, Alter Script on the Actions menu to open the Alter Script Schema Generation dialog.
• Click Preview to review the changes to your schema, and then click Generate to generate the alter script to your database.

  Note: If you are not connected to your target server, you are prompted to make the connection before the schema generation starts.

Alter script functionality is also included in the Resolve Differences dialog of the Complete Compare Wizard.