Info |
---|
Available from version 6.0 |
DBSync Cloud Replication allows renaming the Salesforce & MS CRM Objects & fields in Database as table & column while replicating.
...
Database | Number of Characters of Table/Column Name |
Oracle | Greater than 30 |
MySQL | Greater than 40 |
Microsoft SQL Server | Greater than 50 |
- 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.
![](/docs/download/attachments/62357927/Capture2.PNG?version=1&modificationDate=1647278458000&api=v2)
- In this screen capture, there are Salesforce & MS CRM fields with a longer name. Rename as Field(s) is available to rename.
![](/docs/download/attachments/62357927/Capture3.PNG?version=1&modificationDate=1647278458000&api=v2)
- After a successful replication run, the new name for table & column will reflect in the database as shown below.
![](http://help.mydbsync.com/docs/download/attachments/7078031/worddav6ab75fa547cd14cf630413e8afbcee1e.png?version=1&modificationDate=1383766424000&api=v2)
- 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.