Competition: What’s your favorite Redgate tool? Enter now.

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.
Tagged:

Comments

Sign In or Register to comment.