Skip to content
← SQL Data Compare

How can we improve SQL Data Compare?

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Include History tables together with temporal tables in comparison

I need to compare and sync history of temporal tables as well when testing our system in different environments. Competitive products already have this feature.

16 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Jakub Valoušek shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jeff Davis commented  ·   ·  Report

    Found this thread. I also need this feature. Trying to run code that uses temporal tables in an Operational Data Store to backfill new fact tables being added to our warehouse. Hard to unit test this without being able to replicate the current and historical records from our test system. I have a work around but it would really be nice if Redgate Data Compare had a way to handle this for me.

  • Michael Irving commented  ·   ·  Report

    I also need this feature. Perhaps it should be a configurable option but it is definitely needed to make sure we have the same data when doing tests.