exec sql before and after

mulmadmulmad Posts: 94
I also use sql data compare to have data from a "clean" db quickly inserted/re-inserted into a new db instance (ie. a new dev. or test db).

Before I do a re-insert I run a few clean-up sql scripts.

It would be nice if I could save sql scripts in my compare project files and have a check-mark-choice to have such scripts (titled) run before or after the data compare.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    Sorry about the delay. We can look into this. Meantime you could use the command line version of Data Compare in a batch file, and script a call to osql.exe to run a script before and after the data compare synchronization.
This discussion has been closed.