|
Home > Archive > SQL Anywhere Mobile > August 2005 > What columns should be present in a row for replication?
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 |
What columns should be present in a row for replication?
|
|
| Jack T. 2005-08-08, 11:25 am |
| Bought the book, but won't see it for a day or two. Before I get the book,
what do I need in my rows?
My guess is these are needed for intelligent conflict resolution:
- Station_ID Tiny Int (PKsegment 1)
- Autoinc Int (PK segment 2)
- LastModified TimeStamp
- At least one unique user column for each table. (E.G. SSN in the employee
table so that nobody can enter two with the same information. In this case
you would want a conflict.)
- Version int (Composed of Station_ID and incrementing number)(maybe)
- Non-replicating version table that contains the latest version for each
station.(maybe)
*If I had an error once-in-awhile, it wouldn't be the end of the world. I
don't see much going to happen in the line of two people changing the same
column for the same row, but I do see multiple people changing different
columns in the same row.
Thanks,
Jack T.
| |
| David Fishburn 2005-08-09, 7:24 am |
| "Jack T." <71045. 3122_No_Spam_Here@co
mpuserve.com> wrote in
news:42f7781b$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:
Jack, try to keep these in just 1 thread. This is the 3rd post of this.
--
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]
| |
| Jack T. 2005-08-09, 11:25 am |
| > Jack, try to keep these in just 1 thread. This is the 3rd post of this.
I don't understand. In my first post I asked several questions and Breck
asked me to ask only one per thread. That makes sense, so I started a new
thread for something that I didn't ask about before. What am I missing?
Are you looking at the messages another way other than a newsreader that you
see something that I don't?
Thanks,
Jack T.
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96AD5567173E
Dfishburnsybasecom@1
27.0.0.1...
> "Jack T." <71045. 3122_No_Spam_Here@co
mpuserve.com> wrote in
> news:42f7781b$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:
>
> Jack, try to keep these in just 1 thread. This is the 3rd post of this.
> --
> 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]
>
| |
| Breck Carter [TeamSybase] 2005-08-09, 1:24 pm |
| Actually, you appear to have posted this message as a reply to the
earlier thread; that message was at 11:09 AM August 8. Some folks get
frosted at reading the same thing more than once :)
Breck
On 9 Aug 2005 08:12:34 -0700, "Jack T."
<71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>
>I don't understand. In my first post I asked several questions and Breck
>asked me to ask only one per thread. That makes sense, so I started a new
>thread for something that I didn't ask about before. What am I missing?
>Are you looking at the messages another way other than a newsreader that you
>see something that I don't?
>
>Thanks,
>Jack T.
>
>"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
> news:Xns96AD5567173E
Dfishburnsybasecom@1
27.0.0.1...
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Breck Carter [TeamSybase] 2005-08-09, 1:24 pm |
| The default action is "last uploaded update wins". You need to
identify which tables that need a different action; it probably is a
small number.
The last modified date is generally not useful for conflict
resolution. What you need is 3 versions of the row: The current
consolidated row, the old value from the remote, and the new
(changing) value from the remote. Those versions are available to you
in a conflict resolution script, and you must write code to compare
the versions and make a business decision about which column values
are going to be actually applied to the row in the consolidated
database. This takes 4 1/2 pages in the book, making it a *long*
section as the book goes :)
Breck
PS SSN isn't unique in the real world, but that's another discussion
:)
On 8 Aug 2005 08:19:55 -0700, "Jack T."
<71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>Bought the book, but won't see it for a day or two. Before I get the book,
>what do I need in my rows?
>
>My guess is these are needed for intelligent conflict resolution:
>- Station_ID Tiny Int (PKsegment 1)
>- Autoinc Int (PK segment 2)
>- LastModified TimeStamp
>- At least one unique user column for each table. (E.G. SSN in the employee
>table so that nobody can enter two with the same information. In this case
>you would want a conflict.)
>- Version int (Composed of Station_ID and incrementing number)(maybe)
>- Non-replicating version table that contains the latest version for each
>station.(maybe)
>
>*If I had an error once-in-awhile, it wouldn't be the end of the world. I
>don't see much going to happen in the line of two people changing the same
>column for the same row, but I do see multiple people changing different
>columns in the same row.
>
>Thanks,
>Jack T.
>
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Jack T. 2005-08-09, 8:26 pm |
| Thank you, and I hope the book gets here soon.
Thanks,
Jack T.
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:jirhf1h2ndlkd62
lbdvbe7b0s3fmq02s0k@
4ax.com...
> The default action is "last uploaded update wins". You need to
> identify which tables that need a different action; it probably is a
> small number.
>
> The last modified date is generally not useful for conflict
> resolution. What you need is 3 versions of the row: The current
> consolidated row, the old value from the remote, and the new
> (changing) value from the remote. Those versions are available to you
> in a conflict resolution script, and you must write code to compare
> the versions and make a business decision about which column values
> are going to be actually applied to the row in the consolidated
> database. This takes 4 1/2 pages in the book, making it a *long*
> section as the book goes :)
>
> Breck
>
> PS SSN isn't unique in the real world, but that's another discussion
> :)
>
> On 8 Aug 2005 08:19:55 -0700, "Jack T."
> <71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Jack T. 2005-08-09, 8:26 pm |
| > Actually, you appear to have posted this message as a reply to the
> earlier thread; that message was at 11:09 AM August 8. Some folks get
> frosted at reading the same thing more than once :)
If I did, I didn't realize it.
Thanks,
Jack T.
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:darhf11cqvejr7o
d8qrp1d05lk62ht43fh@
4ax.com...
> Actually, you appear to have posted this message as a reply to the
> earlier thread; that message was at 11:09 AM August 8. Some folks get
> frosted at reading the same thing more than once :)
>
> Breck
>
> On 9 Aug 2005 08:12:34 -0700, "Jack T."
> <71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Breck Carter [TeamSybase] 2005-08-09, 8:26 pm |
| I sent you an excerpt :)
Breck
On 9 Aug 2005 11:48:28 -0700, "Jack T."
<71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>Thank you, and I hope the book gets here soon.
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Jack T. 2005-08-09, 8:26 pm |
| Very much looking forward to it.
Thanks,
Jack T.
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:232if159iuu0e02
dfl7ui9p9d4cafj1g78@
4ax.com...
>I sent you an excerpt :)
>
> Breck
>
> On 9 Aug 2005 11:48:28 -0700, "Jack T."
> <71045. 3122_No_Spam_Here@co
mpuserve.com> wrote:
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Breck Carter [TeamSybase] 2005-08-10, 7:25 am |
| Check your email
On 9 Aug 2005 13:44:01 -0700, "Jack T."
<Jack. Toering_NO_SPAM_HERE
_@LeadingEdgeITA.com> wrote:
>Very much looking forward to it.
>
>Thanks,
>Jack T.
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:232if159iuu0e02
dfl7ui9p9d4cafj1g78@
4ax.com...
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| David Fishburn 2005-08-10, 11:26 am |
| "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
news:darhf11cqvejr7o
d8qrp1d05lk62ht43fh@
4ax.com of
sybase.public.sqlanywhere.mobilink:
BC> Actually, you appear to have posted this message as a reply to the
BC> earlier thread; that message was at 11:09 AM August 8. Some folks get
BC> frosted at reading the same thing more than once :)
Thankfully it isn't just frosting :-)
If other people are interested in the same topic and start reading a
thread they do not realize the answer may continue in a different
thread. So they are often left hanging with no solution, or perhaps
even the wrong answer since more exploration may have been required.
We try to keep the thread (of one topic) going until completion for
consistency.
--
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]
| |
| Jack T. 2005-08-10, 11:26 am |
| > If other people are interested in the same topic and start reading a
> thread they do not realize the answer may continue in a different thread.<
I got started on the wrong foot it seems. What you say makes sense, and I
will consider that in future posts.
Thanks,
Jack T.
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96AE608B6A7F
Ffishburnsybasecom@1
27.0.0.1...
> "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> news:darhf11cqvejr7o
d8qrp1d05lk62ht43fh@
4ax.com of
> sybase.public.sqlanywhere.mobilink:
>
> BC> Actually, you appear to have posted this message as a reply to the
> BC> earlier thread; that message was at 11:09 AM August 8. Some folks get
> BC> frosted at reading the same thing more than once :)
>
> Thankfully it isn't just frosting :-)
>
> If other people are interested in the same topic and start reading a
> thread they do not realize the answer may continue in a different
> thread. So they are often left hanging with no solution, or perhaps
> even the wrong answer since more exploration may have been required.
>
> We try to keep the thread (of one topic) going until completion for
> consistency.
>
> --
> 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]
>
| |
| Breck Carter [TeamSybase] 2005-08-10, 11:26 am |
| On 10 Aug 2005 06:29:32 -0700, David Fishburn
<fishburn_spam@off.ianywhere.com> wrote:
>If other people are interested in the same topic and start reading a
>thread they do not realize the answer may continue in a different
>thread. So they are often left hanging with no solution, or perhaps
>even the wrong answer since more exploration may have been required.
[in the voice of Jules from Pulp Fiction :] Well, allow me to retort!
I agree that artificially starting a new thread on the same topic as
an *current* *single topic* thread is probably undesirable.
However, there are exceptions: First, a thread discussing multiple
topics *should* be broken into separate threads so more people will
pay attention and offer responses. That is why I suggested Jack T.
should start separate threads. The main purpose of the newsgroup is to
answer direct questions; satisfying lurkers is secondary, and they can
always search via Google Groups.
Second, starting a new thread on the same topic, after a day or so of
no helpful responses, can be justified for the purpose of "kick
starting" the topic again. Do you always read threads that already
have replies? I don't, not always, but I always study the fresh
droppings, er, postings :)
Sometimes the new posting is just a photocopy of the old one, and
that's often useless... the questioner should try to rephrase the
posting. If they do that, and they wait 24 hours, I think it's OK to
start a new thread on the same topic.
Marcellus Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|