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.

hi, we are using shadow based synchornisation (with mobilink), and for some reasons we need to add a new remote database, but this new db is almost empty so we wanto to make complete synchronisation from existed consolidate to this remote (have same image of those tables from cons to remote). Question: 1- would it be enough to change the 'last_modified' field for each shadow table of relevant tables on cons. to the current timestamp? 2- Is there any shorter mean, since the solution 1 will cause also transferring the whole image to all other remotes (huge data transaction). Thanks in advance.

asked 04 Jun '17, 18:37

Baron's gravatar image

Baron
2.1k136149177
accept rate: 48%


When you create a new remote database, the first time that remote database synchronizes, it should sent up a last-download timestamp of '1900-01-01 00:00:00.000'. That value should be less than all the last_download timestamps in your shadow tables, so all the initial data in the consolidated database should be download to the new remote.

Can you describe how you "add a new remote database" ?

Thanks, Reg

permanent link

answered 05 Jun '17, 09:16

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118
accept rate: 37%

thanks for the reply, actually it is done using a ready script. I will check the script and write back the mechanism.

(06 Jun '17, 06:56) Baron
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
×2

question asked: 04 Jun '17, 18:37

question was seen: 1,526 times

last updated: 06 Jun '17, 06:56