2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DBSync Restore Child functionality

Introduction:

DBSync Restore Child functionality is used when restoring more than one record from more than one interlinked account. One value change in account that is interlinked with opportunity and contact the change will reflect in all instance and restore will be done in all instance at once.

Also if you want to match the fields from one Salesforce instance to another and match all fields in all account Restore Child can be used.

This addresses the main issue to data impairment and corruption where the User can restore the entire information to reflect the database if any errors were made.

Steps to Run Restore Functionality:

  1. Login to DBSync SaaS Backup instance
  2. Select the desired profile 

Image Removed

                                                       Fig 1: Add App

                                                           

        3. From the top navigation toolbar Select Restore

Image Removed

        4. From the drop-down menu click Restore Child

Image Removed

        5. From the left panel under SCHEMA click the check boxes for selecting the various schema you want.

            The Query builder will consider all these variables for creating a table.

Image Removed

        6. Click on RUN

Image Removed

       7. The list of all the columns in the database will appear in a table format as shown below:

Image Removed

        This table has details of all accounts from the database

        8.Now if any changes are made to any account in the Salesforce instance you can update that information directly by running the UPDATE command. 

        9.This will update the information newly added into the Account in the Salesforce instance in the database.

       10. Click the checkbox next to the account name which you want to update the new information which has been added to the Salesforce instance.

Image Removed

        11. Click UPDATE

For example: let us consider the following:

Changes have been made to the contact information: Phone number added into one of the accounts. When you click the checkbox next to the account and click UPDATE the information will get updated into the database

        12.The list of account changes made will appear in the table section. Select the check box    next to it and  Click Refresh

Image Removed

        13. The number of records which were updated will appear in the table section below the query builder as shown below:

Image Removed

        14. Once you click REFRESH the Salesforce instance for that account will get RESTORED to the actual details reflected in the database. 

        15. For example: Refresh the Salesforce instance and you will see that the contact information will be updated into the original details that was in the database for that account.

        16. Click Restore Child 

Image Removed

  • A drop-down menu will appear with 2 options: Restore and Restore Child.

  • Click Restore Child

  • Source Metadata

  • This section will show all the accounts and the child items listed in a tree structure.

  • Click NEXT

  • In this example the below will appear:

Image Removed

  • Target Profile

  • Select the target profile (the Salesforce instance that you want to Match)

  • Click the check box next to deleted records if you want to update these in database

  • Select the Profile for which you want to perform this function from the drop-down menu 

Image Removed

  • Click the check box next to Update existing database

Image Removed

  • Click NEXT

  • Validate

  • This step will validate all the records and provide a description of all changes made.

  • The functionality will include interpreting and extracting the schema from the Salesforce instance and Matching fields of Account. If any missing fields are found it will also be listed in this section. 

  • A confirmation mentioning that validation is finished will appear on the screen

Image Removed

  • Click NEXT

  • Notification

  • In this table enter details of the email id which you need the notification to be sent. The Restore report will be sent to this email id

Image Removed

  • Click RESTORE

  • A pop-up confirming the export will appear on the screen