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 object.

For instance, one value change in account that is interlinked with opportunity and contact contacts the change will reflect in all instance instances and restore will be done in all instance instances 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

...

Image Removed

                                                       Fig 1: Add App

                                                           

        profile.

3. From the top navigation toolbar Select Restore.

Image Removed

        4. From the drop-down menu tab click Restore Child.

...

Image Added

        5. From the left panel under SCHEMA click the check boxes checkboxes for selecting the various schema you want.             The Query builder Builder will consider all these variables for creating a table.

...

Image Added

        6. Click on RUN

Image Removed

       7Image Added

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

...

Image Added

        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.

...

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

...

  • 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

        11Image Added

8. Click UPDATE

Image Added

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

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

Image Removed

        13Image Added

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

Image Removed

        14Image Added

11. 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 were in the database for that account.

        1612. Click Restore Child 

Image Removed

...

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

...

Click Restore Child

Child button

The following wizard will appear on the screen after step 14.

  • 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 Added

  • Target Profile

  • Select the target profile (respective to 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

  • menu or User to create a profile to add another Salesforce instance using OAuth.

  • Click the checkbox next in case of including deleted records to restore to the target instance.

Image Added

  • Click the check box next to Update existing databasedatabase 

...

Image Added

  • 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 , they will also be listed in this section. 

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

...

Image Added

  • 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 Added

  • Click RESTORE

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

...