Sync Options - circles-arrows/compare41 GitHub Wiki
Compare41 provides 3 synchronization options that users can choose from. These options, if enabled, will determine the actions that will be performed by the application.
Create will create items in the Target database that only exist in the Source.
Overwrite will overwrite items in the Target database that exist in both with data from Source.
Delete will delete items in the Target database that do not exist in the Source.
Below are some scenarios with configurations that can be helpful in understanding the benefits of enabling certain sync options.
Use Case | Create | Overwrite | Delete | Remarks |
---|---|---|---|---|
I want to restore the column I accidentally deleted. | â | Uncheck the columns you don't want to restore. | ||
I have deleted items in the backup database and I want to mirror the changes to production. | â | Select all the Nodes and Relationships to remove. | ||
I have new items in the backup database that I want to copy to production without overwriting other existing items. | â | Select all the Nodes and Relationships to create. | ||
I want to restore a production database using a backup. | â | â | â | Select all the Nodes and Relationships to backup. |
I want to extract a sub graph to an empty database. | â | â | â | Add included items to sync. |
This option will create items in the target database (net-prod) that are only found in the source database (net-backup).
After synchronization, the 200 items from the source database (net-prod) have been added to the target database (net-backup), resulting in a total of 7800 identical items for the :Application:Process
entity.
This option replaces items in the target database (movie-production) with data from the source database (movie-backup) if they exist in both databases.
After synchronization, both databases now have 40 identical items for the Movie entity.
This option deletes items from the target database (net-prod) that are not present in the source database (net-backup).
When synchronizing, you may encounter issues deleting items if some of them have constraints with other items.
You can proceed by selecting either Force or Continue.
To check the issue, you can select Cancel and click the item that has an issue.
âšī¸ To learn more about sync issues, see Sync Issues.
After synchronization, the 200 items have been removed from the target database (net-prod) because they are not present in the source database (net-backup).