Rename Table or Column
DBSync Cloud Replication Rename Process
DBSync Cloud Replication allows renaming 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 the database.
The 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 a 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.
Database | Number of Characters of Table/Column Name |
Oracle | Greater than 30 |
MySQL | Greater than 40 |
Microsoft SQL Server | Greater than 50 |
Process to Rename
First, go to the Profile Section to select the required profile.
Next, go to Salesforce & MS CRM Sync Object Details tab, Table & columns with longer names will be highlighted to suggest rename.
In this screen capture, there is a Salesforce & MS CRM object with a longer name. This object name is highlighted with the suggestion to rename. Once this object is selected for replication, the Rename Table field is available, in which a new name must be entered & the changes must be saved.
In this screen capture, there are Salesforce & MS CRM fields with a longer name. Rename as Field(s) is available to rename.
After a successful replication run, the new name for table & column will reflect in the database.
This functionality is working with the previous 5x profiles as well.
Users can easily see the custom fields and Table rename from 5x Profile to the 6x Profile.
Now, all the data is available in 6x versions including Column and Table rename.
For all the above changes the user has to add 2 properties in the system.properties like
application=salesforce
adapter.type=salesforce
Once these above changes are done then you can transfer the Profile data from 5x to the 6x.