Synopsis
Synchronizes a target database with the package.
Description
The Sync step involves comparing the database schema and data with the source package, identifying differences, and applying the necessary changes to bring the target database up to date.
How to create the Sync step
Select dbForge DevOps Automation for SQL Server - Sync from Add build step drop-down menu:
Then fill in the following fields:
Customization options
Provide the ID of the package that you want to use to update the target database. This must match that specified in the Build step.
Provide the target database name and the name of the server it belongs to, along with the authentication method. If you chose SQL Server Authentication, you will need to specify user name and password.
Advanced customization options
Specify additional Schema Compare options.
Specify a path to an alternative filter file which will be used for validating the schema to override *.scflt filter file present in the input.
Transaction isolation level
Select the isolation level for the transactions during the sync operation. The available options are the following: Serializable, Snapshot, Repeatable Read, and Read Uncommited.
Note
The Sync step does not allow you to perform a comparison without automatically synchronizing the source and target databases. When executed, the Sync step by default triggers the synchronization process. To obtain a comparison report without synchronizing, you may consider using the dbForge Schema Compare Pro or dbForge Studio for SQL Server Ent or Pro command line instead, and omitting the /sync switch. For example:
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Schema Compare for SQL Server\schemacompare.com" /schemacompare /source connection:"Data Source=DESKTOP-9NIVJ84\SQLSERVER2022;Initial Catalog=A1;Integrated Security=True;User ID=DESKTOP-9NIVJ84\1" /target connection:"Data Source=DESKTOP-9NIVJ84\SQLSERVER2022;Initial Catalog=A2;Integrated Security=True;User ID=DESKTOP-9NIVJ84\1"
If you require customized solutions in your DevOps pipeline, the dbForge tool command line offers a flexible alternative that can be tailored to your specific needs. By using this method, you can configure the command line according to your tasks, and execute the dbForge tool with the required options and parameters.