I'm curious to know whether I can replicate a table in SQL Server where the publisher is a normal table, and the subscriber is a system versioned temporal table? Is that possible?
The intent is to have a DW containing the historical (and current) data of an ODS. The DW being the subscriber, and the ODS being the publisher in this scenario.