Rename Table or Column

DBSync Cloud Replication Rename Process

DBSync Cloud Replication allows renaming the Salesforce & MS CRM Objects & fields in the 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 a longer name is not provided with a new name, the object will not be replicated. If the column with a longer name is not supplied with the new name, the existing name will be shortened to fit the database column name.

The steps involved in using 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

Auto rename columns Settings:

• This setting is used when you have objects or tables with more characters than the limit allowed by the database. For example, the Oracle Database provides for only 30 characters in custom Salesforce fields, and any characters exceeding that will get dropped automatically in your database. To avoid this, activate this setting in your DBSync Cloud Replication instance, where any extra characters can be truncated and replaced with recognizable characters to differentiate between the same database names.

• Click the check box next to enable auto rename columns, and it will automatically update the names of any objects in your Salesforce instance to be within the character limit to avoid deletion.

Manual Rename

This is for renaming the table and column names in the backend. if the client wants to add mutually from the properties file, then the above is how to add it either in the system or the profile [config] file.

For renaming column name add following

rename.account.name=name_1

For renaming table name add following

rename.account=account_1