Hi,

I am upgrading our system to use SQL Anywhere 17 from SQL Anywhere 16. I have an Ultralite database that has 2 publications. One publication is a subset of the tables. For this publication, I defined scripts for just the subset of tables in Mobilink (just like in 16 - actually, I just copied the scripts from 16 to 17).

When I replicate the publication that has just the subset of tables, it fails because Mobilink is looking for download (and other) scripts for the other tables that are not included in the publication.

Before I create the scripts for all the other tables (ml-ignore everything) is there something I'm missing...a switch or option somewhere?

Other info - the app is being upgraded from Windows mobile to WinRT - running on IoT devices.

Thank you,

Paula

asked 09 Apr '18, 13:11

Paula's gravatar image

Paula
126141521
accept rate: 0%


You do not need scripts for tables are not being sync'd as part of the publication. Please note that by default, UL syncs all tables.

Double check your sync parameters to ensure that you are providing a publication name that matches the publication name (defined in UL database).

For example, an UL schema with tables t1,t2, and t3 which has defined a publication as:

create publication p(table t2)

The following sync profile would be used to such only the publication p

MobiLinkUid=u;stream=tcpip;ScriptVersion=v;Publications=p
permanent link

answered 09 Apr '18, 20:15

Chris%20Keating's gravatar image

Chris Keating
7.7k49127
accept rate: 32%

converted 10 Apr '18, 08:41

Volker%20Barth's gravatar image

Volker Barth
40.0k361549819

Thanks, Chris for the confirmation. I didn't have the Publication defined in the replication string.

(10 Apr '18, 08:34) Paula
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:

×371
×161

question asked: 09 Apr '18, 13:11

question was seen: 1,238 times

last updated: 10 Apr '18, 08:34