on 2012 Jan 09 8:13 AM
When I set up a consolidated db, is it mandatory to create the prototype on the remote device too? Or is there any method by which the schema can be generated directly there through mobilink while I try for 'first time' synchronization?
Request clarification before answering.
There is no built-in way for MobiLink server to automatically generate a remote database. Nevertheless, you have several options to do what you want to do.
You can use the MobiLink plug-in to Sybase Central and deploy both to the consolidated and to a remote. The deploy simply generates the remote database, typically to the same machine running Sybase Central, so it is more of a development-time step. This deployed remote database can be used as a starting point for your remotes in the field, but you need figure out how to get the remote databases to the field.
In version 12.0.1, the Central Administration of Remotes feature (http://dcx.sybase.com/index.html#1201/en/mlserver/ml-centraladmin.html*d5e7832), can be used, but only if your remotes are laptops/desktop/server machines. Once it is set up, you can centrally perform application-specific logic at the remotes, including deployment of a MobiLink remote. It isn't nearly as powerful as Afaria because Central Admin of Remotes is more for simple management of synchronization applications, while Afaria is for full-blown device management.
Outside of Central Admin of Remotes, you could create your own deploy process using mlfiletransfer, for example.
FWIW, SQL Remote has a straightforward way of automatically generating a remote database via dbextract, but it only supports SQL Anywhere to SQL Anywhere replication, and some mobile devices like iOS, Android and BlackBerry don't support SQL Remote.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks RussC_FromSybase. We are trying to build sync app for iPad, so SQL Remote isn't the option for sure. I wonder if 'Central Administration of Remotes feature' can be useful, given its limited device support. Any idea? FYI, are using Ultralite as remote storage and MS SQL server as consolidated one. Thank you once again.
Central Admin doesn't apply to iOS devices. But Apple has infrastructure for deploying, updating, and notifying applications which works pretty well.
For iOS, you'll typically bundle an initial database with the application, or else download it from the server after deployment. Bundling with the app is easier to get going, I think. You can also bundle just the schema (as a .sql file), and create/update the device database from that (via the 'alter database schema from file' statement).
Unfortunately the Central Admin of Remotes feature isn't available on iOS.
As for grabbing the schema from the consolidated:
You may find it easiest to extract the schema on a PC or Mac, create a UL database there, manipulate the SQL Anywhere SQL and apply it via DBISQL, then deploy it to your device.
Thanks to both of you for your extended support. Please help me if you please, http://sqlanywhere-forum.sap.com/questions/9295/error-196-sync-failed Thanks in advance again.
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.