SQL Server and DB2 still dont have features like Flashback Table or Flashback Query. SQL Server has snapshots mimicking similar behaviour of Flashback bit it isn’t as fine grained as Oracle. IBM DB2 has time travel query which again isn’t on the same level as Flashback. But all other RDBM’s are playing quick catchup to Oracle.Get your act together Oracle or get left behind.
Flashback in SQL Server 2008
By Shadab Mohammad • • No comments
Category: Uncategorized
Tags: Flashback • Flashback Database • Flashback query • IBM DB2 • Sql Server • SQL Server vs Oracle • Time Travel Query