The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.


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,

asked 28 Oct '14, 03:46

vdcey's gravatar image

accept rate: 33%

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

permanent link

answered 29 Oct '14, 10:31

JBSchueler's gravatar image

accept rate: 16%

edited 29 Oct '14, 10:32


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.


(04 Nov '14, 07:24) vdcey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Oct '14, 03:46

question was seen: 975 times

last updated: 04 Nov '14, 07:24