Deploy from Schema Compare

Last modified: May 3, 2024

1. Launch dbForge Schema Compare for SQL Server.

2. On the toolbar, click New Schema Comparison to open the wizard.

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

• Select Source Control as a source type, the required repository, and the revision from version control.
• Select Database as a target type, the required connection, and the database.

4. Click Compare to run the comparison.

5. In the Schema Comparison document that opens, select the objects you want to synchronize and click Synchronize objects to the target database at the top of the page.

6. On the Output page of the Schema Synchronization Wizard, select Execute the script directly against the target database and click Synchronize to deploy the database to the specified revision.

For more detailed instructions, see the Schema Compare documentation.

Deploy changes with the Schema Compare command line

1. Create a copy of the scripts folder on your local machine or check it out from source control.

2. Deploy the local scripts folder to the target database.

For more detailed instructions, see deploying a scripts folder with the dbForge Schema Compare command line.