Post #58,162
10/21/02 10:26:27 PM
|
What kind of replication are you doing?
In Sql Server you can delete rows w/no transactions. Not possible that "merge" replication is the culprit is it? (i.e. data deleted from the subscriber then merged w/the publisher?)
You probably already know this, but NOBODY should have base table access (except sa of course). SP's for insert/update/delete and SP's or views for selects ;-)
|
Post #58,171
10/21/02 10:48:50 PM
|
Expect no response from Norm...
[link|mailto:curley95@attbi.com|greg] - Grand-Master Artist in IT [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]
Your friendly Homeland Security Officer reminds: Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or Just continue to type on your keyboard, and we'll just sample your DNA.
|
Post #58,379
10/22/02 12:51:47 PM
|
Why's that? Is he no longer active here?
|
Post #58,385
10/22/02 1:03:05 PM
|
Claimed so on the mailing list- but, "Promises, promises..."
|
Post #60,964
11/4/02 4:23:36 AM
|
Get over it
I am back, somewhat, but not as active as before.
I tried to quit, but I cannot quit cold turkey. So I came back because you guys kept on messing with me.
Why not listen to Scott, your Admin here, and just leave me alone, treat me with silence?
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
|
Post #60,965
11/4/02 4:29:26 AM
|
Update on Replication
After having half the data on the database going missing twice, our fearless leader decided that Microsoft SQL Server Replication will not be used.
So now I will attempt to re-write the Replication part using just Visual BASIC, ADO, and whatever I can figure out to copy from one database to another and update the data. This is a trick that even Microsoft, IBM, and other companies have not figured out how to do. Not Replication, but more like Synchronization like a PalmOS device does. Hospital Server has data, our Server has data. We make a change on ours, it gets sent to theirs. They make a change on theirs, it gets sent to ours. We won't always have a connection to their LAN. Some of them have a dial-up, others an encrypted connection and the key changes every 15 seconds to connect to it, and yet others have a VPN that we have to manually connect in order to connect to their network. So SQL Server Replication will not work here, I will have to make a custom VB program to do the Data Copy for them, So simple that they just make the connection, set up the UDL files to point to the Hospital database on our server and the Hospital database on their server, and then they just press a button and start the Data Copy.
Brain Surgery, Rocket Science, Quantum Physics, all child's play next to this. Wish me luck.
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
|
Post #61,028
11/4/02 2:40:38 PM
|
Try MSMQ.
Might work for you.
|
Post #61,084
11/4/02 8:06:19 PM
|
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
11/5/02 2:29:23 AM
|
I've told him how to do it already.
|
Post #64,710
11/24/02 4:30:46 AM
|
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
11/24/02 7:30:37 AM
|
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]
|
Post #61,505
11/6/02 8:37:22 PM
|
Since you're down to synchronization, not replication now -
should you export the data to some simple portable format, and then send it to hospital and/or to the home base? This way you don't need any sophisticated tools over connection, and if you chnage the central data server, you can still support old versions.
--
We have only 2 things to worry about: That things will never get back to normal, and that they already have.
|