|
Home > Archive > SQL Anywhere Mobile > June 2005 > synchronize same data to diffrent db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
synchronize same data to diffrent db
|
|
|
| Hi There,
mobilink:9.0.2.3044
ultralite : 9.0.2
consolidate: oracle 9i
If I use "only changed rows" can I upload the same data in
different times to two different databases or I have to use
"all rows " option and to put a query in the "resolve
conflict"??
In the second case I need a bit of explanation how to do it.
thankyou in advenced
Omri Ziv
| |
| Nick Elson 2005-05-31, 9:24 am |
| I have not tried it out myself but since publications track their
progress independently, setting up two publications and synching
only 1 to each database may work.
<Omri> wrote in message news:429c0aa5.1972.1681692777@sybase.com...
> Hi There,
> mobilink:9.0.2.3044
> ultralite : 9.0.2
> consolidate: oracle 9i
> If I use "only changed rows" can I upload the same data in
> different times to two different databases or I have to use
> "all rows " option and to put a query in the "resolve
> conflict"??
>
>
> In the second case I need a bit of explanation how to do it.
> thankyou in advenced
>
> Omri Ziv
| |
|
| tried that and it didn't work!!!
> I have not tried it out myself but since publications
> track their progress independently, setting up two
> publications and synching only 1 to each database may
> work.
>
>
> <Omri> wrote in message
>
>
| |
| Shuchit 2005-05-31, 11:24 am |
| >> Hi There,
[color=darkred]
> I have not tried it out myself but since publications track their
> progress independently, setting up two publications and synching
> only 1 to each database may work.
>
Actually, you would probably want just one publication, but two or more
different subscriptions ie. one for each consolidated.
Shuchit
| |
|
| > >> Hi There,
> in >> different times to two different databases or I have
> to use >> "all rows " option and to put a query in the
> "resolve conflict"?? >>
> do it. >> thankyou in advenced
>
>
> Actually, you would probably want just one publication,
> but two or more different subscriptions ie. one for each
> consolidated.
>
> Shuchit
tell me more about this subscription what it is and what i
good for and how i do it please??
>
| |
| Breck Carter 2005-05-31, 8:26 pm |
| > Actually, you would probably want just one publication,
> but two or more different subscriptions ie. one for each
> consolidated.
Does this mean MobiLink can effectively do peer-to-peer
synchronization rather than strictly hierarchical?
How does this work for downloaded changes? Will a row
downloaded from one consolidated database be automatically
uploaded to the other one?
Or is this only safe for upload-only tables?
Breck
> in >> different times to two different databases or I have
> to use >> "all rows " option and to put a query in the
> "resolve conflict"?? >>
> do it. >> thankyou in advenced
>
>
> Actually, you would probably want just one publication,
> but two or more different subscriptions ie. one for each
> consolidated.
>
> Shuchit
>
| |
| Shuchit 2005-06-01, 7:24 am |
| Shuchit <me@privacy.net> wrote in news:Xns96676B616BB9
Bsvelkarprivacynet@
127.0.0.1:
>
>
> Actually, you would probably want just one publication, but two or more
> different subscriptions ie. one for each consolidated.
>
> Shuchit
>
Sorry. I missed the UltraLite part of the equation. What I proposed will only
work with ASA remotes, if at all. There is not way to achieve what you are
trying to do with UltraLite, short off duplicating the tables.
Shuchit
| |
| David Fishburn 2005-06-03, 3:24 am |
| Breck Carter wrote in news:429cc7d9.4df7.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
BC>> Actually, you would probably want just one publication,
BC>> but two or more different subscriptions ie. one for each
BC>> consolidated.
BC>
BC> Does this mean MobiLink can effectively do peer-to-peer
BC> synchronization rather than strictly hierarchical?
Using ASA remotes only (not UltraLite), it is possible to upload changes
from the remote to two (or more) different consolidated databases.
You must setup two different synchronization users for this to work.
BC> How does this work for downloaded changes? Will a row
BC> downloaded from one consolidated database be automatically
BC> uploaded to the other one?
Any data downloaded to the device will NOT be synchronized to any other
database.
--
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]
| |
|
| DF>Using ASA remotes only (not UltraLite), it is possible to
DF> upload changes from the remote to two (or more)
different
DF> consolidated databases
let me understand if i work with ultralite i can't upload
the same data to diffrent databases (diffrent mobilinks,ip)?
only if i run two diffrent tables for each mobilink?
Omri Ziv
Q.I.S ltd
| |
| Greg Fenton 2005-06-06, 9:24 am |
| Omri wrote:
> let me understand if i work with ultralite i can't upload
> the same data to diffrent databases (diffrent mobilinks,ip)?
> only if i run two diffrent tables for each mobilink?
>
Yes.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-06, 9:24 am |
| Just to be clear.
A single UltraLite database can synchronize to two different MobiLink
servers that both connect to the same consolidated database. The
anal-retentive part of me wants to make sure you understand the difference
between synchronizing to a MobiLink Server versus synchronizing to a
consolidated database.
--
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
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42a455cc$1@foru
ms-2-dub...
> Omri wrote:
>
> Yes.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
|
| Hi Reg ,
first tell your anal retentive that he probbebly didn't
understood.
now again, i want to upload the same data to fiffrent
mobilink and each mobilink is connected to different user.
i want to do it in "only changed rows" mode.
i can do it with all rows but in evrey synchronization to
the same monbilink i create multiplie rows (i think i can
handle it with rows conflict but i need explnation on it).
Just to be clear.
>
> A single UltraLite database can synchronize to two
> different MobiLink servers that both connect to the same
> consolidated database. The anal-retentive part of me
> wants to make sure you understand the difference between
> synchronizing to a MobiLink Server versus synchronizing to
> a consolidated database.
>
> --
> 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
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in
> message news:42a455cc$1@foru
ms-2-dub...
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-09, 9:24 am |
| > and each mobilink is connected to different user.
Do you mean different database?
I still don't quite understand your question.
--
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
<Omri> wrote in message news:42a7e5f5.259a.1681692777@sybase.com...[color=darkred]
> Hi Reg ,
> first tell your anal retentive that he probbebly didn't
> understood.
> now again, i want to upload the same data to fiffrent
> mobilink and each mobilink is connected to different user.
> i want to do it in "only changed rows" mode.
> i can do it with all rows but in evrey synchronization to
> the same monbilink i create multiplie rows (i think i can
> handle it with rows conflict but i need explnation on it).
>
>
> Just to be clear.
| |
| Greg Fenton 2005-06-09, 9:24 am |
| Omri wrote:
> now again, i want to upload the same data to fiffrent
> mobilink and each mobilink is connected to different user.
Are you saying you want to upload the data to two different
*consolidated databases*? (i.e. each ML server is connected to a
different database)
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Hi guys and thank you for your replies!!
but you didn't understand the serios of the problem.
please look at the attched file and reply,
i f you need more details i'll be happy to give you.
have a nice day
Omri Ziv
| |
| Greg Fenton 2005-06-09, 8:24 pm |
| Omri wrote:
> Hi guys and thank you for your replies!!
> but you didn't understand the serios of the problem.
> please look at the attched file and reply,
The picture you have in that MS-Word doc (please don't post proprietary
formatted documents to the newsgroups) is exactly what I asked in my
last post:
you want to upload the data to two different *consolidated databases*
As Shuchit posted back on June 1 (5:34 AM):
> There is not way to achieve what you are
> trying to do with UltraLite, short off duplicating the tables.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| > Omri wrote:
Hi There!
Greg (or anyone else) if there is know solution to this
problem please give me another way to do it?
can i do it with "all rows" mode and "resolve_conflict"
event??
can you explain more about "resolve_conflict" ?
> you want to upload the data to two different
> *consolidated databases*
>
> As Shuchit posted back on June 1 (5:34 AM):
>
> tables.
>
> 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-06-15, 1:25 pm |
| Omri wrote:
>
> Greg (or anyone else) if there is know solution to this
> problem please give me another way to do it?
The problem is that an UL database is designed to synchronize with one
consolidated. To synchronize with two, you have to perform all sorts of
"hacks".
Can I ask why you think you need to synchronize with 2 consolidateds?
> can i do it with "all rows" mode and "resolve_conflict"
> event??
No. This will not help.
> can you explain more about "resolve_conflict" ?
Resolve conflict is a mechanism to deal with the automatically detected
conflicts that are uploaded. A conflict is defined as any UPDATEd row
uploaded from a remote that has been modified on the consolidated since
the previous synchronization of that remote. In other words, a conflict
is when a row is modified at two different locations (two different
remotes, or a remote and the consolidated) between the synchronizations
of that remote. One goal of distributed database design is to minimize
or eliminate the possibility of conflicts (e.g. only allow one remote to
update rows that it "owns").
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
|
> The problem is that an UL database is designed to
> synchronize with one consolidated. To synchronize with
> two, you have to perform all sorts of "hacks".
>
Greg (wrote)
> Can I ask why you think you need to synchronize with 2
> consolidateds?
Hi Greg !
I will explain you why,
We work with PocketPC,
I have two databases one at the main office and one at the
local office ,one synchronization is to main office by gprs,
and the other database with activesync connection (usb) to
local office with the same data that sent to the main
office.
i understand that i have to have two tables and diffrent
publication to each synchronization but this is a heavy
aritecture i want the same table to sync twice i need a
possibiltty to "touch " the flag that lock the data.
have a nice week,
Omri Ziv
>
> Resolve conflict is a mechanism to deal with the
> automatically detected conflicts that are uploaded. A
> conflict is defined as any UPDATEd row uploaded from a
> remote that has been modified on the consolidated since
> the previous synchronization of that remote. In other
> words, a conflict is when a row is modified at two
> different locations (two different remotes, or a remote
> and the consolidated) between the synchronizations of
> that remote. One goal of distributed database design is
> to minimize or eliminate the possibility of conflicts
> (e.g. only allow one remote to update rows that it
> "owns").
>
> 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-29, 11:24 am |
| Omri wrote in news:42be7950.4e9d.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
O> I will explain you why,
O> We work with PocketPC,
O> I have two databases one at the main office and one at the
O> local office ,one synchronization is to main office by gprs,
O> and the other database with activesync connection (usb) to
O> local office with the same data that sent to the main
O> office.
O> i understand that i have to have two tables and diffrent
O> publication to each synchronization but this is a heavy
O> aritecture i want the same table to sync twice i need a
O> possibiltty to "touch " the flag that lock the data.
O> have a nice week,
Generally what people do is multi-tiered synchronization.
UltraLite syncs to your desktop via activesync (only).
The desktop syncs to the consolidated.
In this case, the data will still move to the consolidated, it will just
take an extra hop through the desktop database.
--
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]
|
|
|
|
|