Good Afternoon, I'm newer in mobilink technology so I don't know if my question is valid:
I have to load default data on the ultralite database, to avoid init synchronization(because is large amount of data) But mobilink is going to download all the data because in ml_subscription table is no reference of the lastdownload date. How can I achieve this? Is it possible? Thank you.
Assuming the database that is embedded in the resources is empty ("fresh database") and has never been synchronized, you simply need to synchronized it - the first sync will set the remote id and last download timestamp.
If you want to embed a pre-populated database and you are not worried about building it regularly, you can use Sybase Central to perform the first sync, then use Sybase Central or dbisql to reset the remote id (see 3.2 below) before embedding into the resources.
If you want to build it regularly:
What version of UltraLite and what API are you using?
answered 08 Jun '11, 21:26
The key is to create the initial database by synchronization, instead of otherwise, because the official last download time is stored at the remote, not in the consolidated. Only the remote knows if the download has been applied, so it is stored there. Here's the approach:
1) Synchronize a fresh database. This may indeed take a while, but you'll only have to do it once.
2) Copy the database to the remote somehow (See Phil's followup post)
3) Set the
Your case is pretty much spelled out in the documentation. See: http://dcx.sybase.com/index.html#1201/en/uladmin/fo-dbprops-s-4074568.html*d5e11109
Frequently you may find that downloading a pre-populated database using the ML file transfer facility is much faster than doing a large initial sync (because of index building, etc).
This initial database can be built on the fly, or you could have a task do a nightly/weekly/monthly build of one which all new clients share.
On the server that builds the initial database (using ulinit or ulload), you can use the ulsync utility to synchronize the db initially thus giving it good last download timestamps.
If a number of clients will be receiving this pre-sync'ed db, make sure you reset the ML remote id on the database (I think you can use a utility to do this or you can have the clients do it after download).
p.s. Edit your tags and change "dbmlsync" to "ultralite"
answered 08 Jun '11, 10:20