How can we help you today? How can we help you today?

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

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
0

Comments

3 comments

Sort by
  • mjashton
    No-one?
    mjashton
    0
  • Mark J
    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.
    Mark J
    0
  • mjashton
    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.
    mjashton
    0

Add comment

Please sign in to leave a comment.