At 01:02 PM 9/4/2008 -0400, MB Software Solutions General Account wrote: >On Thu, September 4, 2008 1:48 pm, Charlie Coleman wrote: > > Nah, the MS evangelicals are having meetings all month, trying to figure > > out a way to save the company. I got the memo (not sure why though, I > > removed myself from their "fanatics" list many years ago - I suppose SQL > > Server screwed things up... again). > >Come on, Charlie...let's be fair. Which do you think would have more >issues typically: the SQL Server database or the equivalent Fox database? > Most would say the latter (due to corruption, invalid memo, etc.). IF >ITS CONFIGURED CORRECTLY, I would expect SQL Server to perform reliably >and well.
Well, I can only go on my experience. I've had more problems from SQL Server than I ever have had with VFP. I've got a couple systems that work with SQL Server to store data: but guess what, I duplicate all that data in a VFP database as well. Thank God I did, I've been able to restore the SQL DB about 3 times in the past 5 years when it had major problems. And let me clarify: some of the "problems" I have encountered with distributed VFP DBs has been when an IT department goes off and deletes some of the files in the database (I think they see the ".fpt" extension and think it's some kind of "ftp" script and they get all scared - strange how we have this level of incompetence in the computer industry... then again, the incompetence I've seen has been mainly related to Windows certified something-or-others....<shrug>). But I don't label that a VFP "problem." Other than that, I've never had problems with VFP DBs on a centralized server (aka using West Wind as the access vehicle for external requests, rich apps communicating over a LAN, etc). I've seen lots of posts on here about people having problems, I've just not had them myself. So, while my post was in jest, nope, I do not trust SQL Server any more than I'd trust MS with my bank account info (hmmm... which they may have since I did have to log on to a Vista machine a few days ago). Side note, I've dabbled slightly with MySQL and PostgeSQL and think they're great. But since I haven't had major work or projects done with them, I can't really claim a high degree of comfort with them right now. :-) -Charlie PS. Wait, I think there was a problem I did actually see a few years back. It had something to do with a Novell network and something else. I don't remember if it caused database corruption or if the system simply couldn't access data. But then again, to me that is not a VFP "problem" (the same Novell issue caused problems for other applications as I recall. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
