I am trying to automate order processing for a client; their POS provider does not have any API with their software, so I was hoping to be able to insert orders directly into the database.
so I want to take a snapshot of the database, enter the order manually, and then take another snapshot and compare 2 snapshots to see what was done.
Is there a tool around that can parse two snapshots of SQL Server and output the sql differences file?
Please do not lecture me that this is a bad idea, I already know the risks of a mess with someone elses data directly
source
share