Export a datasource to script folder

rickybibi

Why the "RedGate.SQLCompare.Engine.Options.SeparateTriggers" doesn't working ?

Is there a way to force to generate triggers scripts to a separe folder and/or files than the tables ?

Thanks

JonathanWatts

Hi rickybibi,

That option is actually an internal one and should not being displayed in VS or the API help, hopefully we will tidy this up shortly. It was put in place to serve a possible future need, but will have no effect on the scripts produced as the engine will overide this setting.

More grandural control of objects like indexes, triggers etc, is a very popular request, and one we are consider addressing.

Regards,

Jonathan

Michelle T

In the meantime, if you manually seperate the table and the trigger into seperate script files, then SQL Compare will try and update the seperate script files instead of combinding the two objects again. Occasionally (e.g. if you change the name of the trigger) it will put the trigger back in with the table, but most operations preserve the structure you've set up with them in different scripts.