Generate change script

ERBuilder provides a schema-database synchronization feature that allows you to compare your model with an existing database, see the differences between their structures and generate a synchronization SQL script.

To synchronize your database with your model follows these steps:

1.         Select “Tools | Generate change script” from the main menu

image  

Select a connection to your target database, and click “Connect” to test the connection.

Note: The connection to the database must be created and configured from “File” > “Manage Connections”. See the section “Connections Management” for more details.

image

2.         Choose the object(s) to include in the comparison and synchronization process from the section “compare options”. By default, all objects are selected.

 

3.         Click the “Next” button to start the comparison process. When the comparison is finished, the differences will appear in the result window grouped by objects.

image

4.         Now, you can click the “Generate Change Script” button to generate the synchronization DDL script.

Available in: Standard, Professional and Enterprise Editions