Generating Schema Synchronization Scripts

How to generate synchronization scripts

Click the Advanced button and select Generate synchronization SQL.

Advanced button in Luna Modeler.

A new window opens. Select the database connection from the Target Database Connection drop down. The connection details and settings for comparison will be displayed.

Click the Load database and detect differences button.

Settings and detection of database schema changes in Luna Modeler data modeling tool.

Luna Modeler loads the database structure and displays a list of detected differences.

The result of SQL database comparison. A list of detected differences is displayed.

Then click the SQL Script tab to see the generated alter scripts and other SQL statements.

Delta scripts for database schema changes

Video – How to generate Sync SQL Scripts

Video – How to generate ALTER scripts for Oracle

Related articles

#

DATA MODELING TOOLS
DRAW Diagrams and
GENERATE Scripts
Download data modeling tools
Blog Categories
Blog by Platforms