Rename Table or Column

DBSync Cloud Replication Rename Process

DBSync Cloud Replication allows to rename the Salesforce & MS CRM Objects & fields in Database as table & column while replicating.

This function is applicable only when the name is too long for database.

Number of characters in the table name & column name to rename varies from database to database as mentioned below. If the object with longer name is not provided with new name, the object will not be replicated. If the column with longer name is not provided with the new name, the existing name will be shortened to fit the database column name.

Steps involved to use this feature are mentioned in this section.

Process to Rename

1. First, go to Profile Section to select the required profile.
2. Next, go to Salesforce & MS CRM Sync Object Details tab, Table & columns with longer names will be highlighted to suggest rename.
3. In this screen capture, there is a Salesforce & MS CRM object with the longer name. This object name is highlighted with the suggestion to rename. Once this object is selected for replication, Rename Table field is available, in which new name must be entered & the changes must be saved.
   
   
   
   
4. In this screen capture, there are Salesforce & MS CRM fields with the longer name. Rename as Field(s) is available to rename.
   
   
   
   
5. After successful replication run, the new name for table & column will reflect in database as shown below.