Add Custom Script

sriramphani · April 16, 2010 12:49PM

Hi,

I'm comparing tables and we have updater that executes the saved scripts from Data Compare to all the terminals.

Now we have decided to run some scripts on terminal 1 and rest on terminal 2. I do have a function that determines whether it is terminal 1 or terminal 2.

After comparison, I would like to include that function as a condition to the generated script which will run only on terminal 1 but not on terminal 2. I can include that manually after every data compare. But is there a way to automatically add

IF(Terminal1() = 1)
BEGIN
Generated Script
END

so that I don't have to do it manually?

Thanks,
Sriram.

peter.peart · April 19, 2010 3:33PM

Hi there,

This isn't something that is currently supported within SQL Data Compare, however the workaround is to simply alter the script yourself.

I am curious, would you see this as a option where you could write in your own script that would be run by SQL Data Compare, or implemented in some other way?

Many thanks!

Pete

sriramphani · April 19, 2010 4:11PM

I'm currently using data compare to compare and sync data. But before saving the script, I would prefer if I have an option to edit the script.

Anyway, I will continue to save the script and edit the script and then run the script manually.

Thanks for your reply,
Sriram.

David Atkinson · April 19, 2010 7:20PM

We're considering adding a 'pre-deployment script' feature in the next major release but only if there's enough interest. If anyone else would benefit from this feature please respond to this thread!

David Atkinson
Product Manager
Red Gate Software

Add Custom Script

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk