exec sql before and after
mulmad
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.
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.
This discussion has been closed.
Comments
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.