How can we help you today? How can we help you today?

Show Changes since a last saved report

I have 2 databases -
ArchiveDB_2024q1 (which contains the final results at Q1 qtr end March31 '24)
LiveDB (which contains the current results)

I want to compare LiveDB vs. ArchiveDB_2024q1 at 2 different points in time: 

June 15 - to show changes vs. Q1 at June 15 '24
June 30 - to show changes in the Q2 final results (finalize June 30 '24) vs. Q1 

I can easily do this with SQL Compare and even save the results (Cntl -R) in a hard copy file
My Q - How do I show only the differences between June 15 and June 30 w/o making a 3rd DB?  
cgott42
0

Comments

3 comments

Sort by
  • cgott42
    Likewise, Can I save a Schema and then use it as a basis for a comparison to the live database at a later point in time?
    cgott42
    0
  • DanC
    Hi @cgott42

    If you were using SQL Source Control to track your schema changes, you could select a specific revision for comparison to achieve this

    SQL Compare, doesn't natively allow you to set a specific comparison window and will just compare everything

    For the second question, you can save the schema to a scripts' folder for comparing at a later date
    DanC
    0
  • cgott42
    thx
    cgott42
    0

Add comment

Please sign in to leave a comment.