Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

For timestamp based syncronization Mobilink suggests last_modified as the timestamp column. Is it possible to default this to LastModified to adapt the MobiLink setup to our existing naming convention? I know I can change it manually but it would be really nice to be able to default this.

For deletes using shadow tables MobiLink suggests {OWNER}.{TABLE}_del as table name, where owner is the owner of the original table. Is it possible to default this to something else, like Ml.{TABLE}Deleted, as well as defaulting the triggers to Ml{Table}OnDelete and Ml{Table}OnInsert. Again, this is for naming conventions only. I am aware of the possibility to override the syncrhonization scrips and write my own logic but MobiLink doesn't generate the shadow tables and triggers automatically on deployment if I override the synchronization scripts, which is a big loss.

asked 23 Apr '12, 04:58

OskarEmil's gravatar image

OskarEmil
431161831
accept rate: 50%

edited 23 Apr '12, 08:32

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


You don't have to manually change the timestamp column name for each table mapping if you enter the name you want when creating the sync model. Note that you'd have to change the name on two pages for each new model: on the Timestamp Download Options page for downloads and on the Download Deletes page for the generated delete shadow tables. Those column names are then used for all table mappings, including ones that are added later.

There is no UI for changing the shadow table owner, suffix, or trigger names. You could try editing the the *-pattern attributes for the <sync-settings> elements in your MLSM file using a text or XML editor. That wouldn't let you change the shadow table owner though, and you would need to make sure the scripts were regenerated when you next opened the model in Sybase Central.

permanent link

answered 03 May '12, 18:22

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843
accept rate: 29%

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

question asked: 23 Apr '12, 04:58

question was seen: 1,288 times

last updated: 03 May '12, 18:22