SQL Anywhere Mobile - Re: ASA /SQL Sudio 9.0.2 on Server but Ultralite 8.0.2 on Pocket

Author

Re: ASA /SQL Sudio 9.0.2 on Server but Ultralite 8.0.2 on Pocket

Greg Fenton

2005-05-04, 3:25 am

handheldmaster wrote:
>
> Not tried any of the 9.x yet ... Will be downloading eval
> version to install and play around. Is 9.0.3 the latest rev
> ? When does sybase plan to release the next rev ///

Breck was joking. 9.0.2 is the latest. I have not seen an announcement
as to whether there will even be a 9.0.3.

> Would you know if there has been any synchornization
> characteristic additions/changes/new features for how
> download_delete cursors work where one deletes something on
> the consolidated and we need to delete it on the remote
> database.

In this respect, there is no difference between 8.x and 9.x. What kind
of changes were you hoping for or expecting?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Greg Fenton

2005-05-05, 9:24 am

handheldmaster wrote:
>
> Was wondering if the newer major rev's would have something
> that will keep a table between Consolidated & Remote
> "in-sync". If one deletes something from the consolidated
> these get applied to the remote and vice-a-versa.

Since the ML server is nothing more that an ODBC *client application* to
the consolidated, then there is nothing we can do if you physically
delete a row from the consolidated. ML doesn't "know" that the row is gone.

Remember ML supports RDBMS's over which iAnywhere has not control. I
doubt that those other vendors are about to open their engine internals
to ML engineers...

Realize that other synchronization and replications have similar
problems. They either support just their own database (thus have access
to engine internals) or they put the onus on the synch script developers
(just like ML does).

Note that there are now tools that will help you automate the process of
setting up triggers and shadow tables, etc... in the consolidated. For
example PowerDesigner 11 has the "Information Liquidity Model" to allow
you to design a synchronization solution (including picking different
synchronization techniques per table) and to generate remote or
consolidated schemas based on the ILM.

For Jasper (SQLAnywhere 10), there are also new ML administration tools
coming. Watch these newsgroups for future announcements.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links