Handling Source Tables with Long Table or Column Names
Handling Source Tables with Long Table or Column Names
If you have source tables with long table or column names, alternative strategies are available for shortening these names when generating corresponding audit log tables or target tables. Otherwise, the table names on the target might exceed the maximum length that the target database allows.
Merge Apply mode requires a target table and audit log table that correspond to each source table on the target. Audit Apply mode requires an audit log table only. Also, if you use InitialSync with the Bulk Copy Program (BCP) to load data to Microsoft SQL Server targets based on a configuration that includes SQL expressions, InitialSync requires audit log tables to process the SQL expressions in SQL Apply mode.
If you use Merge Apply mode, SQL Apply mode for the special InitialSync with BCP processing case, or Audit Apply mode with table mappings based on wildcard expressions or exact name matching, audit log table names include the suffix that is defined on the
Runtime Settings
tab >
Calculated Columns
view. Also, the before- and after-image columns in the audit log tables have suffixes that are defined on the
Calculated Columns
view. You can shorten the table and column suffixes to comply with name length limits of the target database.