We have a complex process that creates various entries into a large database. I would like to generate a single SQL script that performs all the writes that are done by a single run of this process. For example, if I run complex process it might do:

  1. Insert ...
  2. Insert ...
  3. SELECT ...
  4. Update ...
  5. Insert ...

I want to extract 1 script that does:

  1. Insert, Insert, Update, Insert

I don't care about the SELECT because that is a read. Is there a tool that can do this? Note that if the tool also creates the reads that is fine as they can simply be ignored.

  • For which DB engine/s?
    – Alejandro
    Jun 9, 2015 at 14:50
  • Updated question to show ms-sql Jun 9, 2015 at 15:09


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.