Deploy from Schema Compare

You can deploy changes from source control to a database using the Schema Compare feature in dbForge Studio.

To deploy changes using Schema Compare:

1. To open the New Schema Comparison wizard, in the top menu, select Comparison > New Schema Comparison.

2. On the Source and Target page of the wizard, do the following:

For Source, select Source Control, choose the required repository, and select the desired revision.
For Target, select Database, choose the appropriate connection, and select the target database.

3. Click Compare.

Deploy changes using the Schema Compare functionality

4. In the Schema Comparison document, select the objects you want to synchronize, then select Synchronize objects to the target database at the top of the document.

5. On the Output page of the Schema Synchronization Wizard, select Execute the script directly against the target database and click Synchronize to apply the changes and deploy the database to the selected revision.