Review the deployment script
Last modified: September 6, 2024
In this topic, you will learn how to obtain the database deployment script, and we will also provide guidance on getting the deployment script for an individual database object or entity.
Get the deployment script
After you have completed the comparison process and obtained the comparison results, Data Compare can automatically generate the deployment script.
1. Click Synchronize
2. The Data Synchronization Wizard gets opened. To review the script, choose one of the following options.
Open the synchronization script in the internal editor
The option allows you to open the script in the editor of dbForge Data Compare. For example:
Save the script to a file
This option allows you to save the script to a file on your PC. To specify the file name and directory, click
Under Save the script to a file, you have two additional options:
-
Open script in the internal editor: This allows you to open the script within the dbForge Data Compare editor.
-
Append timestamp to the file name: With this option enabled, the date and time will be added to the file name.
Also, you can open the saved file with dbForge Data Compare and review the deployment script. For this you need to select Open script in the internal editor.
3. After you have chosen the required option, click Synchronize.
View the deployment script for a single object
1. To review the deployment script for one object, select the desired object. For example:
2. Click Synchronize, select your preferred output option for the deployment script, and click Synchronize again.
You’ll see the script with the object you have chosen.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by Data Compare for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.