IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / how will you resolve last write issues on the same record?
Post #61,084
by boxley
11/4/02 8:06:19 PM
Reply
New how will you resolve last write issues on the same record?
hospital db
server db
temp work db
both hospital and server put changes to temp db which has a copy of server db at a specific point in time like 00:05 am during the day as things are update replace the hospital db with tempdb using a copy function. at midnight replace server with tempdb rinse and repeat. Might want to ask tablizer to verify but it should be able to be done in xbase in a matter of hours. Trouble is your not using xbase.
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]

"Money for jobs? No first you get the job, then you get the money" Raimondo
Post #61,122
by CRConrad
11/5/02 2:29:23 AM
Reply
New I've told him how to do it already.
Post #64,710
by orion
Picture of orion
11/24/02 4:30:46 AM
Reply
New Thanks, but I lost that job.
I told them the way you wanted me to do it, and the boss said "No".

It may have led to my firing, suggesting Interbase and other Borland products. After he read the email I sent him on it, he slammed his fists down on the desk, packed up his laptop after shutting it down, and then ran out the door muttering "Damn programmers...." or something like that.
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
Post #64,729
by CRConrad
11/24/02 7:30:37 AM
Reply
New Yeah, sure - that must be why I did it. (new thread)
Created as new thread #64728 titled [link|/forums/render/content/show?contentid=64728|Yeah, sure - that must be why I did it.]
   Christian R. Conrad
Mechanisation
As our souls are slowly stolen
The wheels of progress keep steamrolling
Mechanisation melts our minds
To drive the furnace that drives us blind. -- [link|http://www.vergenet.net/~conrad/poetry/mechanisation.html|© Conrad Parker, 1993]
     SQL Server Database loses half of its records and indexes - (orion) - (27) - Oct. 18, 2002, 06:58:17 PM EDT
         SQL Database loses half of its records and indexes - (gdaustin) - (14) - Oct. 18, 2002, 10:09:13 PM EDT
             Recipe for doom - (tablizer) - (13) - Oct. 25, 2002, 11:19:48 PM EDT
                 Re: Recipe for doom - (jlalexander) - (12) - Oct. 26, 2002, 03:38:31 PM EDT
                     I'd disagree as well, but not so strongly. - (mmoffitt) - (11) - Oct. 26, 2002, 06:18:53 PM EDT
                         DBA's fault? - (tablizer) - (10) - Oct. 28, 2002, 02:22:42 AM EST
                             Have an example handy? - (ChrisR) - (8) - Oct. 28, 2002, 09:37:21 AM EST
                                 Actually there was a bug in Sql 7.0. - (mmoffitt) - (7) - Oct. 29, 2002, 06:58:07 PM EST
                                     Seen lots of SQL generate "incorrect" results... - (gdaustin) - (6) - Oct. 30, 2002, 11:06:21 AM EST
                                         Those dang outer joins - (wharris2) - Oct. 30, 2002, 11:10:57 AM EST
                                         Why does it care about line-ends in the first place?!? -NT - (CRConrad) - (3) - Oct. 30, 2002, 11:15:37 AM EST
                                             Re: Why does it care about line-ends in the first place?!? - (gdaustin) - (2) - Oct. 30, 2002, 11:51:17 AM EST
                                                 We do the same thing here. - (admin) - (1) - Oct. 30, 2002, 11:52:45 AM EST
                                                     We've done that, too. - (static) - Oct. 31, 2002, 06:30:42 AM EST
                                         Speaking of incorrect results... - (Meerkat) - Nov. 2, 2002, 12:35:34 AM EST
                             Possibly - (wharris2) - Oct. 28, 2002, 01:15:04 PM EST
         What kind of replication are you doing? - (mmoffitt) - (11) - Oct. 21, 2002, 10:26:27 PM EDT
             Expect no response from Norm... -NT - (folkert) - (3) - Oct. 21, 2002, 10:48:50 PM EDT
                 Why's that? Is he no longer active here? -NT - (mmoffitt) - (2) - Oct. 22, 2002, 12:51:47 PM EDT
                     Claimed so on the mailing list- but, "Promises, promises..." -NT - (CRConrad) - (1) - Oct. 22, 2002, 01:03:05 PM EDT
                         Get over it - (orion) - Nov. 4, 2002, 04:23:36 AM EST
             Update on Replication - (orion) - (6) - Nov. 4, 2002, 04:29:26 AM EST
                 Try MSMQ. - (mmoffitt) - Nov. 4, 2002, 02:40:38 PM EST
                 how will you resolve last write issues on the same record? - (boxley) - (3) - Nov. 4, 2002, 08:06:19 PM EST
                     I've told him how to do it already. -NT - (CRConrad) - (2) - Nov. 5, 2002, 02:29:23 AM EST
                         Thanks, but I lost that job. - (orion) - (1) - Nov. 24, 2002, 04:30:46 AM EST
                             Yeah, sure - that must be why I did it. (new thread) - (CRConrad) - Nov. 24, 2002, 07:30:37 AM EST
                 Since you're down to synchronization, not replication now - - (Arkadiy) - Nov. 6, 2002, 08:37:22 PM EST

Our Internal Subterfuge is up 80%! Good Job, way to go!
110 ms