Limitations and considerations

The following limitations apply to the File target endpoint:

Only the following DDLs are supported: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.
Full LOB Mode is not supported
UPDATE and DELETE statements are not supported in Apply Changes replication mode
Batch optimized apply mode is not supported
Target lookup is not supported
The <target folder> parameter cannot include special characters
When the When source table is altered Apply Changes setting is set to Ignore ALTER, data files will be updated, but metadata files and metadata headers (if defined) will not.
Source schema and table names cannot contain periods. If they do, you should use a global transformation to remove/replace the periods; otherwise, data loss will occur.
Database names, schema names, or table names containing slash (/) or backslash (\) characters are not supported.
The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:
- Replication Status (requires UPDATE).
  Name on target: attrep_status
- Suspended Tables (requires DELETE).
  Name on target: attrep_suspended_tables
  For more information on Control Tables, see Control tables.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!