Automate and schedule SQL database synchronization from the Command Line - dbForge Compare Bundle

In this demo, we will show you:

- How to set up the deployment of changes from the source databases to the target ones,
- How to create a *.bat file using the Command-Line Wizard,
- How to create a daily database synchronization task using Windows Task Scheduler.

We will be using dbForge Compare Bundle, a powerful set of tools for handling changes in SQL Server data and schemas.
It contains two separate tools: Data Compare and Schema Compare.
The Schema Comparison Wizard opens for you to check the databases you want to compare and set the options as required.
To sync DB diffs, you can use the Command-Line Wizard that allows setting up the deployment options and preview the contents of the *.bat file.
You can configure the Windows Task Scheduler to automatically run the synchronization.

⭐️Timestamps:
00:38 Let's compare two SQL databases on different servers.
00:52 Select Source and Target Databases.
1:10 configuring the comparison options.
1:20 Start the comparison process to detect differences between the two databases.
1:35 Create the batch file for database synchronization using the Command-Line Wizard.
1:58 Run the *.bat file to deploy the changes directly to the database.
2:03 Check successful deployment of the detected differences.
02:55 Configure the Windows Task Scheduler to automatically run the synchronization.
03:45 Test out the scheduled task for synchronization databases differences.

??That's it! Try it yourself - just download a 30-day free trial of dbForge Compare Bundle
https://www.devart.com/dbforge/sql/compare-bundle/download.html
Start saving time and effort when performing routine database comparison and deployment tasks.
??Check more useful information:
https://www.devart.com/dbforge/sql/compare-bundle/
►Subscribe to the Devart Youtube channel:
https://www.youtube.com/user/DevartSoftware

#CompareBundle
#SchemaCompare
#DataCompare
#SQLServer
#SQLDatabase
#dbForge
#Devart