CODEWITHSUNDEEP
sqlsql-servertemporal-database
Chuu
Chuu

Reputation: 4509

Does MSSQL currently have any features similar to "PERIOD" columns in SQL2011?

I have a project where the PERIOD columns defined in the SQL2011 spec are the perfect solution. Unfortunately, I am forced to use MSSQL 2008R2 (or possibly MSSQL 2012) as my database, which does not support this feature.

Is there any proprietary feature that resembles the PERIOD features in SQL2011 currently in MSSQL? If not, any advice for the best way to try to implement something resembling it?

Upvotes: 0

Views: 457

Answers (1)

dubmojo
dubmojo

Reputation: 6838

Take a look at Anchor Modelling. I know it's not exactly what you're looking for, (a PERIOD equivalent) but databases implemented as an Anchor model can include bi-temporal aspects. The generated SQL code when exporting the model primarily supports MS SQL. Oracle is available too but a lot of work when into optimizing the schema, trigger and view SQL code for MS SQL. Maybe it'll help, maybe you can see how they implemented bi-temporal data in a way that works really well with MS SQL.

Upvotes: 1

Related Questions