How to modify the design of a temporal table which is already in use in EF6 and not lose the data?

Alvaro CP 1

I've started to use Temporal tables with EF6 and always that I want to modify a column name or make any easy change in a table that is temporal or system-versioned, I have to recreate the table, losing the former data. We are in development right now and there is not any problem with that but what happens when we'll be in production?
I'm thinking seriously to discard the Temporal tables with the Entity framework, it looks pretty fancy but I think it's still not fully supported.

Jack J Jun 24,286 Reputation points Microsoft Vendor

2022-03-11T08:36:08.053+00:00

@Alvaro CP , as usual, If you want to use EF to deal with database problem and you want to add other columns to the database, It is hard to save the initial data because you need to do the migration or code first again after you add the new columns or change some columns.
Alvaro CP 1 Reputation point

2022-03-14T12:20:43.447+00:00

Yeap, I´ve seen that it´s not very worth it if you want to implement a flexible app and need adaptability for different clients.