The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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
654222839
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.1k2837
accept rate: 15%

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:

×412
×295

question asked: 28 Oct '14, 03:46

question was seen: 738 times

last updated: 04 Nov '14, 07:24