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,

asked 28 Oct '14, 03:46

vdcey's gravatar image

vdcey
654212836
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

JBSchueler
2.0k2836
accept rate: 16%

edited 29 Oct '14, 10:32

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,

(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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×409
×285

question asked: 28 Oct '14, 03:46

question was seen: 696 times

last updated: 04 Nov '14, 07:24