Are there any options for how to script out the data synchronisation script?

mjashton · June 16, 2017 10:55AM

I can't find any options for how the script created by

provider.GetMigrationSQL

is structured. For example, with Schema Compare scripts you can specify options for

DropAndCreateInsteadOfAlter

to allow idempotence but I can't find anything similar for data synchronisation, which will just do INSERTS if it thinks the row is missing.

Ideally I'd like to do a similar DropAndCreate on the static data.

mjashton · June 29, 2017 8:13AM

No-one?

Mark J · June 29, 2017 12:23PM

There are some options you can set in EngineDataCompareOptions - the Options property of the ComparisonSession that gets passed into GetMigrationSQL which will affect the deployment script. However, there isn't currently an option similar to DropAndCreateInsteadOfAlter from SQL Compare. There is a very popular uservoice request for this feature, though - we don't have any definite plans to work on it at the moment but we hope we can implement it in the future.

mjashton · July 12, 2017 2:11PM

Thanks for the link - it obviously gets my vote! It seems impossible to make idempotent scripts (via automation) without this kind of feature, unless I'm missing something else. Thanks again.

Are there any options for how to script out the data synchronisation script?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk