1

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 '15 at 14:50
  • Updated question to show ms-sql – P.Brian.Mackey Jun 9 '15 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.