What does "Set Script Version" do in "Start Synchronization Schema Change" ?

[Former Member]

Hi,

Here I am asking another question on mobilink synchronizations :-)...

I am in the middle of updating publications on client machines and i do this by the following command:

"Alter synchronization subscription to somepublication alter option sv='myscriptversion'"

Now, it looks like I can Only update existing tables with foreign keys IF i place them inside the following script:

"Start synchronization schema change for tables A, B Set script version = 'myscriptversion';"

// Add foreign keys to A and B tables

"Stop synchronization schema change;"

---

so my question => since I am already updating my publication, why is there a "Set script version" command in the "start synchronization schema change" command ?

thanks in advance,

[jack_schueler · Accepted solution]

Have you had a look at this topic? -> Script versions and subscriptions

[Former Member · Accepted solution]

Hi,

I see, so the script version in schema change is a different legacy approach. I guess I'll have to remember to use the correct version in both places.

thanks,