I set the script version with script:

ALTER SYNCHRONIZATION SUBSCRIPTION uploadtope
SET SCRIPT VERSION = 'vup_1';

Is there a sql script to retrieve the script version?

asked 08 Dec '20, 01:57

ontsnapt's gravatar image

ontsnapt
1107917
accept rate: 0%

It's unclear to me exactly what you are asking. Both Chris and I have provided responses that answer the question correctly, but make different assumptions on what you are asking. If we haven't answered your question, please clarify your question.

(08 Dec '20, 08:56) Reg Domaratzki

The SQL that Chris provided is used at the consolidated database, and will let you know what script versions are defined, allowing you to verify that when you synchronize a remote database to this consolidated database, that the 'vup_1' script version exists at the consolidated database.

If you would like to know which script version a remote database will use when you synchronize the synchronization subscription named 'uploadtope', you would execute the following SQL on the remote database :

select script_version from SYS.SYSSYNC where subscription_name = 'uploadtope';

Reg

permanent link

answered 08 Dec '20, 08:54

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.1k340111
accept rate: 38%

edited 08 Dec '20, 09:01

This information is in the MobiLink system table ML_SCRIPT_VERSION.

i.e., select NAME from ML_SCRIPT_VERSION

permanent link

answered 08 Dec '20, 07:14

Chris%20Keating's gravatar image

Chris Keating
5.8k3597
accept rate: 32%

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:

×364

question asked: 08 Dec '20, 01:57

question was seen: 990 times

last updated: 08 Dec '20, 09:01