| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-20, 8:25 pm |
| Note : This may have been better suited in the UltraLite forum. Since
nobody else is responding, I'll answer, but I'm by no means an UltraLite
expert, and I've never used MobileVB beyond the tutorial in the docs.
The idea of multiple publications in an UltraLite remote was to implement
priority synchronizations. Your plan to use publications in UltraLite
should be fine as long as none of your tables belong in more than one
publication.
No reference database is needed to Synchronize from an UltraLite client to
an Oracle consolidated. You'll need to define your schema file, which can
be created either by running ulinit against an ASA database (i.e. a
reference database) or can created using the UltraLite Schema Painter. If
the schema of your remotes never changes, once you have your USM file,
you'll never need to touch the schema painter or ulinit again. If the
schema is changing, it's up to you as to whether you want to maintain your
schema using the Schema Painter or by maintaining a reference database and
running ulinit to generate your USM files.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Jeffrey Kelly" <jeff_kelly@fishgame.state.ak.us> wrote in message
news:42b357fd$1@foru
ms-1-dub...
>
> I have developed a test environment using ASA (version 9.0.2.3044) as
> the remote database, and Oracle (version 9i 9.2.0.1.0) as the
> consolidated. I have used Mobilink (version 9.0.2.3044) *publications*
> to accomplish the synchronization.
>
> The target production implementation will use Ultralite as the remote
> database and Oracle as the consolidated.
>
> Is it best practice to use Mobilink publications to synchronize
> Ultralite with Oracle? We expect to eventually have a number of
> different sync needs; all from the same remote db to the same
> consolidated db.
>
> Is it true that no reference database would be necessary when syncing
> between Ultralite on handhelds and Oracle as the consolidated?
>
> We are using Ultralite for Crossfire/MobileVB to develop our apps.
>
> Thanks!!!
|