Mobilink script version

[former_SQLA_member1694909]

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?

[regdomaratzki]

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.

[regdomaratzki]

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

[chris_keating]

This information is in the MobiLink system table ML_SCRIPT_VERSION.

i.e., select NAME from ML_SCRIPT_VERSION