Basically, you’ll want to enable system-versioning for the source table to a history table which you’ve decided will be temporal. That being the case, you’ll need a couple additional columns of ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...