If you get the error message:

1. Migrates published Catalog Content has failed with exception 'System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.

or

2. Failed to clean up meta keys: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

What you can try is to change these two settings:

For exception 1 what you can try is to decrease the batch size for DraftMigrationBatchSize (Default is 5000)

<add key="ecf:DraftMigrationBatchSize" value="10000" />

For exception 2 what you can try is to decrease the batch size for RemoveOrphanedMetaKeysBatchSize (Default is 10,000)

<add key="ecf:RemoveOrphanedMetaKeysBatchSize" value="1000" />