SQL Anywhere Mobile - How to intialize remote db??

Author

How to intialize remote db??

Sanjay

2005-05-31, 8:26 pm

ASA/ML 9.0.1 (1922)

Hi All,

At client site, we have to install softare on 15 HH.
First sync., where it loads all the intial data, takes around 20 min.
Can I sync. the first HH, drop publication and use that db
as starting point for other devies?
But then i don't want them to sync same info again.
How to accomplish this?

thanx

Sanjay

Reg Domaratzki $iAnywhere Solutions$

2005-06-02, 7:24 am

Yes, this is possible, but involves a little bit of schema work on the
remote, and some extra scripts defined for MobiLink.

The easier thing to do would be to do the first synchronization for the HH
on a desktop and them deploy the database to the HH after the first
synchronization. If this isn't possible, let me know and I can post some
details on a more complicated solution.

--
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

"Sanjay" <sas@sasintl.com> wrote in message news:429cca08$1@foru
ms-1-dub...
> ASA/ML 9.0.1 (1922)
>
> Hi All,
>
> At client site, we have to install softare on 15 HH.
> First sync., where it loads all the intial data, takes around 20 min.
> Can I sync. the first HH, drop publication and use that db
> as starting point for other devies?
> But then i don't want them to sync same info again.
> How to accomplish this?
>
> thanx
>
> Sanjay
>
>

Sanjay

2005-06-02, 9:24 am

Got it to work by
a. first sync. on HH
b. download db to desktop
c. drop subscription for ml user
d. upload db on HH
e. Dropped mluser from consolidate db
f. Created subsctiption for ml user.
g. manuplated script
h. sync. again

Now only i can ever get delete_old_log to work...hopefully some day -:)

Thanks for you reply..

Sanjay.

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:429efc35$1@foru
ms-1-dub...
> Yes, this is possible, but involves a little bit of schema work on the
> remote, and some extra scripts defined for MobiLink.
>
> The easier thing to do would be to do the first synchronization for the HH
> on a desktop and them deploy the database to the HH after the first
> synchronization. If this isn't possible, let me know and I can post some
> details on a more complicated solution.
>
> --
> 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
>
> "Sanjay" <sas@sasintl.com> wrote in message
news:429cca08$1@foru
ms-1-dub...
>
>

Greg Fenton

2005-06-02, 11:24 am

Sanjay wrote:
> Got it to work by
> a. first sync. on HH

You could do the first synch on the desktop, which would likely be MUCH
faster.

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

David Fishburn

2005-06-03, 3:24 am

"Sanjay" <sas@sasintl.com> wrote in news:429f1c20@forums
-2-dub of
sybase.public.sqlanywhere.mobilink:

S> Got it to work by
S> a. first sync. on HH
S> b. download db to desktop
S> c. drop subscription for ml user
S> d. upload db on HH
S> e. Dropped mluser from consolidate db
S> f. Created subsctiption for ml user.
S> g. manuplated script
S> h. sync. again
S>
S> Now only i can ever get delete_old_log to work...hopefully some day
S> -:)

I didn't think this would work, but this will work:

http://ianywhere.codexchange.sybase...ctDocumentList?
folderID=319&expandFolder=319&folderID=0

Choose this sample:
Overriding MobiLink's LastDownload Date
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sanjay

2005-06-03, 8:24 pm

Thanks David
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns9669E0F64828
7fishburnsybasecom@1
27.0.0.1...
> "Sanjay" <sas@sasintl.com> wrote in news:429f1c20@forums
-2-dub of
> sybase.public.sqlanywhere.mobilink:
>
> S> Got it to work by
> S> a. first sync. on HH
> S> b. download db to desktop
> S> c. drop subscription for ml user
> S> d. upload db on HH
> S> e. Dropped mluser from consolidate db
> S> f. Created subsctiption for ml user.
> S> g. manuplated script
> S> h. sync. again
> S>
> S> Now only i can ever get delete_old_log to work...hopefully some day
> S> -:)
>
> I didn't think this would work, but this will work:
>
> http://ianywhere.codexchange.sybase...ctDocumentList?
> folderID=319&expandFolder=319&folderID=0
>
> Choose this sample:
> Overriding MobiLink's LastDownload Date
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD number with
> EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> [url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>

Sponsored Links