I love the feature "copy table to" for migrating content from or legacy database to a new database.
The new scheme contains two additional columns "DateCreated" and "DateModified" which have to be != NULL.
When using the "copy table to"-feature I am able to modify the scheme of the destination table, so that there is a default value "now()". This works, but I'd like to leave the scheme as it is and set a default value only for the migration.
How can I achieve that?