Database Rating tech memo

[ontsjc]

I'm putting together a technical memo on the advantages and disadvantages of different Desktop DBMS for a client.&nbsp;&nbsp;Could anyone please post (briefly, not interested in reading a dissertation, just a few quick points) the strengths and weakness of the following:<br><br>Visual Foxpro&nbsp;&nbsp;(my favorite)<br>Access<br>Oracle<br><br>Thanks

 

[JDurbin]

Access - a 'power users' database management tool<br><br>visual foxpro - a true developers tool, used with native data is as fast or faster than data servers or used as client/server thru odbc/ado to data source.&nbsp;&nbsp;local data or 'views' can be 'upsized' to oracle or sql server leaving vfp as a front end or middle or n-tier typically for business rules<br><br>oracle - back end data server, robust, secure, scalable, etal - serving data as the back end of an n-tier structure<br><br>Btiefly you said.&nbsp;&nbsp;HTH<br>John Durbin

 

[ontsjc]

Thanks.&nbsp;&nbsp;That was what I was looking for.&nbsp;&nbsp;Glad I was directed to this forum

 

[SBTBILL]

Let me add with lots of indexes and a seek with a do while you get instantious results.&nbsp;&nbsp;Much faster then SQL.&nbsp;&nbsp;Disadvantage 2 gig file limit.<br>