Show Changes since a last saved report

cgott42

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?  

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 

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

thx